Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- USE ExpensiveCars
- GO
- DECLARE @ds datetime
- DECLARE @de datetime
- SET @ds = GETDATE()
- PRINT @ds
- INSERT INTO TestRuns(Description, StartAT, EndAt) VALUES ('View', @ds, @ds)
- EXECUTE RunViewTestsProc
- SET @de = GETDATE()
- UPDATE TestRuns
- SET EndAt = @de
- WHERE Description = 'View'
- SET @ds = GETDATE()
- INSERT INTO TestRuns(Description, StartAT, EndAt) VALUES ('Insert', @ds, @ds)
- INSERT INTO TestRuns(Description, StartAT, EndAt) VALUES ('Delete', @ds, @ds)
- EXECUTE RunTableTestsProc
- SET @de = GETDATE()
- UPDATE TestRuns
- SET EndAt = @de
- WHERE Description = 'Insert' OR Description = 'Delete'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement