Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Use CS435S14HW1
- --Delete Order Detail result 1, 1 and 1
- DELETE FROM OrderDetail where OrderNumber = 223 and LineNumber = 2
- if @@ROWCOUNT <> 1 PRINT 'Error: Deleting Order line should have affected 1 row'
- SELECT * FROM OrderHeader where OrderNumber = 223
- if @@ROWCOUNT <> 1 PRINT 'Error: Deleting Order line deleted the header'
- SELECT * FROM OrderDetail where OrderNumber = 223
- if @@ROWCOUNT <> 1 PRINT 'Error: Deleting Order line failed'
- --Delete Order result 1, 0 and 1
- DELETE FROM OrderHeader WHERE OrderNumber = 228
- if @@ROWCOUNT <> 1 PRINT 'Error: Deleting Order header should have affected 1 row'
- select * from OrderDetail where OrderNumber = 228
- IF @@ROWCOUNT <> 0 PRINT 'Error: Deleting Order header did not cascade to the lines'
- select * from Contact where ContactID = 105
- IF @@ROWCOUNT <> 1 PRINT 'Error: Deleting Order deleted contact'
- --Delete Vendor without any Order result 1
- delete from Contact where ContactID = 79
- IF @@ROWCOUNT <> 1 PRINT 'Error: Deleting vendor failed'
- --Delete a Carrier from an unshipped, standard, order
- update OrderHeader set Carrier = null where OrderNumber = 172
- IF @@ROWCOUNT <> 1 PRINT 'Error: Remove Carrier failed'
- --Check final record count in all tables
- declare @count integer
- SELECT @count = COUNT(*) FROM Item
- IF @COUNT <> 194 PRINT 'Error: Count of Items = '+convert(varchar, @count)+' should have been 194'
- SELECT @count = COUNT(*) FROM Contact
- IF @count <> 173 PRINT 'Error: Count of Contacts = '+convert(varchar, @count)+' should have been 173'
- SELECT @count = COUNT(*) FROM OrderHeader
- IF @count <> 239 PRINT 'Error: Count of Orders = '+convert(varchar, @count)+' should have been 239'
- SELECT @count = COUNT(*) FROM OrderDetail
- IF @count <> 259 PRINT 'Error: Count of details = '+convert(varchar, @count)+' should have been 259'
- use Master
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement