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