root/trunk/SQL/StoredProcedures/proc_NowaPlatnoscEcard.txt @ 844

SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[proc_NowaPlatnoscEcard] 
        @ORDERDESCRIPTION VarChar(30),
        @idFaktury Int,
        @nip VarChar(20),
        @nrZlecenia VarChar(50) = NULL,
        @AMOUNT Int,
        @CURRENCY Char(3),
        @SESSIONID VarChar(120),
        @NAME VarChar(25),
        @SURNAME VarChar(30),
        @AUTODEPOSIT Bit,
        @LANGUAGE char(2),
        @CHARSET VarChar(20),
        @COUNTRY Char(3),
        @JS Bit,
        @PAYMENTTYPE VarChar(20)
AS
insert into PlatnosciEcard(ORDERDESCRIPTION, IDFaktury, nip, nrZlecenia, AMOUNT, CURRENCY, SESSIONID, NAME, SURNAME, AUTODEPOSIT, [LANGUAGE], CHARSET, COUNTRY, JS, PAYMENTTYPE) values (@ORDERDESCRIPTION, @idFaktury,  @nip, @nrZlecenia, @AMOUNT, @CURRENCY, @SESSIONID, @NAME, @SURNAME, @AUTODEPOSIT, @LANGUAGE, @CHARSET, @COUNTRY, @JS, @PAYMENTTYPE)
        select @@IDENTITY AS 'ID'
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO