tag:blogger.com,1999:blog-6082652835152798567.post3410432238718423797..comments2024-03-28T21:41:58.974-07:00Comments on Sql server, .net and c# video tutorial: Transaction Acid Tests - Part 58Unknownnoreply@blogger.comBlogger3125tag:blogger.com,1999:blog-6082652835152798567.post-62324456834772073132023-06-06T21:34:05.887-07:002023-06-06T21:34:05.887-07:00drop table if exists tblProduct1;
Create Table tb...drop table if exists tblProduct1; <br />Create Table tblProduct1<br />(<br /> ProductId int,<br /> [Name] nvarchar(10),<br /> UnitPrice int,<br /> QtyAvailable int<br />)<br /><br />Insert into tblProduct1 values (1, 'laptop', 2340, 90)<br />Insert into tblProduct1 values (2, 'desktop', 3467, 50)<br /><br />drop table if exists tblProductSales1; <br />Create Table tblProductSales1<br />(<br /> ProductSalesId int NOT NULL primary key,<br /> ProductId int,<br /> QuantitySold int<br />)<br /><br />Insert into tblProductSales1 values (1, 1, 10)<br />Insert into tblProductSales1 values (2, 1, 10)Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-59773457585472152232020-12-26T17:04:26.519-08:002020-12-26T17:04:26.519-08:00the main purpose of the transaction is to ensure ...the main purpose of the transaction is to ensure either all commands succeed/ failure(rolled back).there is obligation for transaction to follow acid property(by definition).So i belive violation of ACID property means violation of transaction definition ...........vijayhttps://www.blogger.com/profile/15121955634662830956noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-56438245902606335092016-11-03T05:42:19.562-07:002016-11-03T05:42:19.562-07:00Hello Sir. Could you be that kind to tell me some ...Hello Sir. Could you be that kind to tell me some examples of <br />violation each of this ACID properties of the transaction? What could possibly happen to undermine atomicity, consistency, isolation, durability?<br /> Anonymousnoreply@blogger.com