set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo].[STPIsGoodExist] @GoodTitle nvarchar(1000), @GoodCode int=0 AS if @GoodCode<>0 if exists(SELECT GoodSyscode FROM StockTbl WHERE (Title = @GoodTitle) AND (GoodSyscode <> @GoodCode)) return 1 else return 0 else if exists(SELECT GoodSyscode FROM StockTbl WHERE (Title = @GoodTitle) ) return 1 else return 0