IF EXISTS(SELECT ConvertState
FROM BusinessBaseInfo
WHERE BusinessID = #{businessID})
BEGIN
--如果存在
SELECT ISNULL(ConvertState, -1) ConvertState
FROM BusinessBaseInfo
WHERE BusinessID = #{businessID}
END
ELSE
BEGIN
--如果不存在
SELECT -1 ConvertState
END
IF EXIST(
– 作为判断条件的sql
)
BEGIN
– 存在sql
END
ELSE
BEGIN
– 不存在sql
END