set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO create PROCEDURE [dbo].[STPIsCheckInExist] @SerialNo bigint, @CheckDate nvarchar(1000)='' , @ACCNo nvarchar(1000)='' AS if exists(SELECT FK_DocSysCode FROM CheckInTBL WHERE (ACCNo = @ACCNo) AND (SerialNo = @SerialNo) AND (CheckDate = @CheckDate)) return 1 else return 0