SQL
Create a Transaction for the Production.ProductInventory table that
A) Changes the value of the Quantity for ProductID 317, Location 5 to 158 to 159
B) Changes the value of Quantity for ProductID 316, Location 5, from 532 to -4.
The transaction must have both a "commit" and "rollback".
Run the transaction and show any error message. Display the contents of those 2 rows to verify that the transaction did what it was supposed to do.
Results Messages LocationID 50 Shelf ProductID 3 Bin 9 to CC . 10 6 4 1 10 11 4 B 10 12 50 11 P P A A 13 11 68591 14 B 4 316 316 316 317 317 1 10 50 15 B 8 16 C 1 17 1 5 50 Quantity rowguid 324 1339E5E3-1F8E-4B82-A447-48666A264FOC 512 6BEAFOA0-971A-4CE1-96FE-692807D5DC00 422 2C82427A-63F1-4877-A1F6-A27B4D201EB6 388 FD912E69-EFA2-4AB7-82A4-03F5101AF11C 532 1EE3DBD3-2A7E-47DC-AF99-1B585575EFB9 388 CB2A24D7-9870-4140-8836-9EB759262103 441 36B375A3-022A-45BF-B425-DBFFAAC3145A 283 C04FC1CF-1D2B-4480-BA13-64C6EF780F4B 158 83332A73-48A9-401D-95F4-385C944D716F 152 4072C90C-A867-4F64-882F-EC45ADA1B79C 136 F287EFD3-CCC5-4344-9F4A-E588BBF29801 171 B62232E8-90B5-4DA1-BFE1-453AA1917EFC 132 D758C516-D9BF-4AA6-8E57-F5BD6D568F97 308 7367821F-BB8B-4102-86ED-A7FB7054F8E1 184 BFB760AC-0767-4F76-8670-49488D0F731D 305 FEBBCC76-2764-48A3-A086-77D1E883137C 481 BD134ECD-D4DA-406C-A7CE-7EC40F9BCF... 372 DEEDBA07-171B-4038-88A5-A57166E8F446 283 4FEF28B3-6652-4D3A-999B-00784D401542 ModifiedDate 2008-03-31 00:00:00.000 2014-08-08 00:00:00.000 2014-08-08 00:00:00.000 2014-08-08 00:00:00.000 2008-03-31 00:00:00.000 2008-03-31 00:00:00.000 2008-03-31 00:00:00.000 2014-08-09 00:00:00.000 2014-08-09 00:00:00.000 2014-08-09 00:00:00.000 2014-08-09 00:00:00.000 2014-08-09 00:00:00.000 2014-08-09 00:00:00.000 2014-08-09 00:00:00.000 2014-08-09 00:00:00.000 2014-08-09 00:00:00.000 2014-08-09 00:00:00.000 2014-08-09 00:00:00.000 2014-08-09 00:00:00.000 317 21 18 19 20 318 2 5 2 318 318 21 50 A 22 22 319 C 3 - g 319 A 3 23 24 25 50 A 23 319 320 4 UC 26 320 A 4 27 320 50 24 Results Messages LocationID 50 Shelf ProductID 3 Bin 9 to CC . 10 6 4 1 10 11 4 B 10 12 50 11 P P A A 13 11 68591 14 B 4 316 316 316 317 317 1 10 50 15 B 8 16 C 1 17 1 5 50 Quantity rowguid 324 1339E5E3-1F8E-4B82-A447-48666A264FOC 512 6BEAFOA0-971A-4CE1-96FE-692807D5DC00 422 2C82427A-63F1-4877-A1F6-A27B4D201EB6 388 FD912E69-EFA2-4AB7-82A4-03F5101AF11C 532 1EE3DBD3-2A7E-47DC-AF99-1B585575EFB9 388 CB2A24D7-9870-4140-8836-9EB759262103 441 36B375A3-022A-45BF-B425-DBFFAAC3145A 283 C04FC1CF-1D2B-4480-BA13-64C6EF780F4B 158 83332A73-48A9-401D-95F4-385C944D716F 152 4072C90C-A867-4F64-882F-EC45ADA1B79C 136 F287EFD3-CCC5-4344-9F4A-E588BBF29801 171 B62232E8-90B5-4DA1-BFE1-453AA1917EFC 132 D758C516-D9BF-4AA6-8E57-F5BD6D568F97 308 7367821F-BB8B-4102-86ED-A7FB7054F8E1 184 BFB760AC-0767-4F76-8670-49488D0F731D 305 FEBBCC76-2764-48A3-A086-77D1E883137C 481 BD134ECD-D4DA-406C-A7CE-7EC40F9BCF... 372 DEEDBA07-171B-4038-88A5-A57166E8F446 283 4FEF28B3-6652-4D3A-999B-00784D401542 ModifiedDate 2008-03-31 00:00:00.000 2014-08-08 00:00:00.000 2014-08-08 00:00:00.000 2014-08-08 00:00:00.000 2008-03-31 00:00:00.000 2008-03-31 00:00:00.000 2008-03-31 00:00:00.000 2014-08-09 00:00:00.000 2014-08-09 00:00:00.000 2014-08-09 00:00:00.000 2014-08-09 00:00:00.000 2014-08-09 00:00:00.000 2014-08-09 00:00:00.000 2014-08-09 00:00:00.000 2014-08-09 00:00:00.000 2014-08-09 00:00:00.000 2014-08-09 00:00:00.000 2014-08-09 00:00:00.000 2014-08-09 00:00:00.000 317 21 18 19 20 318 2 5 2 318 318 21 50 A 22 22 319 C 3 - g 319 A 3 23 24 25 50 A 23 319 320 4 UC 26 320 A 4 27 320 50 24
