Advertisement
Guest User

For Eric Homework 1 CS435

a guest
Oct 31st, 2014
156
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 1.80 KB | None | 0 0
  1. Use CS435S14HW1
  2.  
  3. --Delete Order Detail result 1, 1 and 1
  4. DELETE FROM OrderDetail where OrderNumber = 223 and LineNumber = 2
  5. if @@ROWCOUNT <> 1 PRINT 'Error: Deleting Order line should have affected 1 row'
  6. SELECT * FROM OrderHeader where OrderNumber = 223
  7. if @@ROWCOUNT <> 1 PRINT 'Error: Deleting Order line deleted the header'
  8. SELECT * FROM OrderDetail where OrderNumber = 223
  9. if @@ROWCOUNT <> 1 PRINT 'Error: Deleting Order line failed'
  10.  
  11. --Delete Order result 1, 0 and 1
  12. DELETE FROM OrderHeader WHERE OrderNumber = 228
  13. if @@ROWCOUNT <> 1 PRINT 'Error: Deleting Order header should have affected 1 row'
  14. select * from OrderDetail where OrderNumber = 228
  15. IF @@ROWCOUNT <> 0 PRINT 'Error: Deleting Order header did not cascade to the lines'
  16. select * from Contact where ContactID = 105
  17. IF @@ROWCOUNT <> 1 PRINT 'Error: Deleting Order deleted contact'
  18.  
  19. --Delete Vendor without any Order result 1
  20. delete from Contact where ContactID = 79
  21. IF @@ROWCOUNT <> 1 PRINT 'Error: Deleting vendor failed'
  22.  
  23. --Delete a Carrier from an unshipped, standard, order
  24. update OrderHeader set Carrier = null where OrderNumber = 172
  25. IF @@ROWCOUNT <> 1 PRINT 'Error: Remove Carrier failed'
  26.  
  27. --Check final record count in all tables
  28. declare @count integer
  29. SELECT @count = COUNT(*) FROM Item
  30. IF @COUNT <> 194 PRINT 'Error: Count of Items = '+convert(varchar, @count)+' should have been 194'
  31. SELECT @count = COUNT(*) FROM Contact
  32. IF @count <> 173 PRINT 'Error: Count of Contacts = '+convert(varchar, @count)+' should have been 173'
  33. SELECT @count = COUNT(*) FROM OrderHeader
  34. IF @count <> 239 PRINT 'Error: Count of Orders = '+convert(varchar, @count)+' should have been 239'
  35. SELECT @count = COUNT(*) FROM OrderDetail
  36. IF @count <> 259 PRINT 'Error: Count of details = '+convert(varchar, @count)+' should have been 259'
  37.  
  38. use Master
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement