有没有办法在数组中检查CASE:
SELECT CASE [Option] WHEN IN (1,3,99) THEN 'Wrong option' ELSE 'You go!' END
解决方法
SELECT CASE WHEN [Option] IN (1,99) THEN 'Wrong option' ELSE 'You go' END