set xact_abort on; go begin transaction; go set ANSI_NULLS on; go /*************************************** * STORED stp_dateProxScadenze * * ottiene elenco date x prossime scadenze * * Steamware, S.E.L. * mod: 2012.05.07 * ****************************************/ create PROCEDURE stp_dateProxScadenze ( @dataMin DATETIME ) AS SELECT * FROM v_dateEsecuzione WHERE (Data >= CAST(@dataMin AS datetime)) ORDER BY Data RETURN go commit; go -- registro versione... INSERT INTO [dbo].[LogUpdateDb] ([Versione],[Data]) VALUES(135, GETDATE()) GO