Advertisement
SkyElit3

Untitled

Dec 12th, 2019
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.60 KB | None | 0 0
  1. USE ExpensiveCars
  2. GO
  3.  
  4. DECLARE @ds datetime
  5. DECLARE @de datetime
  6. SET @ds = GETDATE()
  7. PRINT @ds
  8. INSERT INTO TestRuns(Description, StartAT, EndAt) VALUES ('View', @ds, @ds)
  9.  
  10. EXECUTE RunViewTestsProc
  11.  
  12. SET @de = GETDATE()
  13. UPDATE TestRuns
  14. SET EndAt = @de
  15. WHERE Description = 'View'
  16.  
  17. SET @ds = GETDATE()
  18. INSERT INTO TestRuns(Description, StartAT, EndAt) VALUES ('Insert', @ds, @ds)
  19. INSERT INTO TestRuns(Description, StartAT, EndAt) VALUES ('Delete', @ds, @ds)
  20.  
  21. EXECUTE RunTableTestsProc
  22.  
  23. SET @de = GETDATE()
  24. UPDATE TestRuns
  25. SET EndAt = @de
  26. WHERE Description = 'Insert' OR Description = 'Delete'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement