Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --CREATE PROCEDURE run_achizitie AS BEGIN
- -- DECLARE @data1 DATETIME, @data2 DATETIME, @data3 DATETIME, @data4 DATETIME
- -- SET @data1 = GETDATE()
- -- EXEC delete_achizitie
- -- EXEC add_achizitie
- -- SET @data2 = GETDATE()
- -- SET @data3 = GETDATE()
- -- EXEC view_2
- -- SET @data4 = GETDATE()
- -- INSERT RulariTeste
- -- VALUES ('tabel_2 + view_2',@data1,@data4)
- -- INSERT RulariTesteTabele
- -- VALUES ((SELECT MAX(CodRulareTest) FROM RulariTeste),2,@data1,@data2)
- -- INSERT RulariTesteViewuri
- -- VALUES ((SELECT MAX(CodRulareTest) FROM RulariTeste),2,@data3,@data4)
- --END
- --GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement