Torna al Thread

CREATE PROCEDURE [dbo].[insDittaToDo] -- Parametri @p1 nvarchar(max), --nome ditta @p2 nchar(3), --codAlfaDitta @p3 nvarchar(50), --tipoditta @p4 char(1), --periodicità ditta @p5 nvarchar(max) = '', --descrizioneDitta @p7 varchar(15), --pIVA @p8 int = 0, --1 iva si 0 iva no @p9 int = 0, --1 bilancio si 0 bilancio no @idNew int OUTPUT AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; -- Inserisco la ditta declare @idNewTmp int declare @idOgg int declare @idItem int insert into tblDitta (nomeDitta, codAlfaDitta, tipoDitta, periodicitaDitta, descrizioneDitta, PIVA) values(@p1, @p2, @p3, @p4, @p5, @p7) select @idNewTmp = @@IDENTITY set @idNew = @idNewTmp END
Copyright © dotNetHell.it 2002-2024
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5