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