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