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