DECLARE @CASE int declare @id varchar(100) select @id = ID FROM TABLE WHERE CONDITION A AND CONDITION B if charindex(@case,@id) > 0 return true else return false
哈,太有意思了 DECLARE @CASE intset @CASE = 10if ID IN( SELECT ID FROM TABLE WHERE CONDITION A AND CONDITION B)RETURN TRUE
DECLARE @CASE intset @CASE = 10if exists( SELECT 1 FROM TABLE WHERE CONDITION A AND CONDITION B)RETURN TRUE
DECLARE @CASE int
declare @id varchar(100)
select @id = ID FROM TABLE WHERE CONDITION A AND CONDITION B
if charindex(@case,@id) > 0
return true
else
return false
DECLARE @CASE intset @CASE = 10if ID IN(
SELECT ID FROM TABLE WHERE CONDITION A AND CONDITION B)RETURN TRUE
SELECT 1 FROM TABLE WHERE CONDITION A AND CONDITION B)RETURN TRUE