EXISTS的使用
IF NOT EXISTS (SELECT 0 FROM [train_enroll_data] WHERE [courseId] = 636235546473141211)
BEGIN
SELECT CAST(1 AS BIT)
END
ELSE
BEGIN
SELECT CAST(0 AS BIT)
END
EXISTS的使用
IF NOT EXISTS (SELECT 0 FROM [train_enroll_data] WHERE [courseId] = 636235546473141211)
BEGIN
SELECT CAST(1 AS BIT)
END
ELSE
BEGIN
SELECT CAST(0 AS BIT)
END