Advertisement
ostyleo

Untitled

Dec 14th, 2017
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.60 KB | None | 0 0
  1. --CREATE PROCEDURE run_achizitie AS BEGIN
  2. -- DECLARE @data1 DATETIME, @data2 DATETIME, @data3 DATETIME, @data4 DATETIME
  3. -- SET @data1 = GETDATE()
  4. -- EXEC delete_achizitie
  5. -- EXEC add_achizitie
  6. -- SET @data2 = GETDATE()
  7.  
  8. -- SET @data3 = GETDATE()
  9. -- EXEC view_2
  10. -- SET @data4 = GETDATE()
  11.  
  12. -- INSERT RulariTeste
  13. -- VALUES ('tabel_2 + view_2',@data1,@data4)
  14. -- INSERT RulariTesteTabele
  15. -- VALUES ((SELECT MAX(CodRulareTest) FROM RulariTeste),2,@data1,@data2)
  16. -- INSERT RulariTesteViewuri
  17. -- VALUES ((SELECT MAX(CodRulareTest) FROM RulariTeste),2,@data3,@data4)
  18. --END
  19. --GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement