set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[AddPrintLayout] ( @FKID int, @LayoutName nvarchar(50), @Xmldata varbinary(Max), @PrimaryLayout bit, @ID int output ) AS Begin if @id >0 update PrintLayouts set XMLdata=@XmlData where id=@id else begin INSERT INTO PrintLayouts (LayoutName, XMLdata, PrimaryLayout, FKID) VALUES (@LayoutName,@XmlData,@PrimaryLayout,@FKID) SET @ID=(select IDENT_CURRENT('PrintLayouts')) end END