set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[StpCreateGridLayoutFilter] (@LayoutId int=0 ,@Field nvarchar(1000)='' ,@DisplayText nvarchar(1000)='' ,@FilterText nvarchar(1000) ='' ,@FilterId int=0 output ,@Replace bit =0) AS if @filterid=0 begin INSERT INTO GridFilterTitleTbl (LayoutId, DisplayText) VALUES (@layoutId,@DisplayText) set @filterid=@@identity end if @Replace =1 UPDATE GridFilterTitleTbl SET DisplayText = @DisplayText WHERE (SysCode = @FilterId) else INSERT INTO GridLayOutFilterTbl ( Field, FilterText, FK_FilterId) VALUES (@Field,@FilterText,@FilterId)