我试图用sql做这个case语句，但语法不正确，怎么了？有没有一种方法可以用sql实现这一点？
CASE WHEN @TESTVALUE LIKE 'a%' OR @TESTVALUE LIKE 'b%' THEN RETURN WHEN @TESTVALUE LIKE 'c%' THEN SET @var1 = 'var1c' SET @var2 = 'var2c' ELSE SET @var1 = 'var1other' SET @var2 = 'var2other' END
CASE
WHEN @TESTVALUE LIKE 'a%'
OR @TESTVALUE LIKE 'b%' THEN
RETURN
WHEN @TESTVALUE LIKE 'c%' THEN
SET @var1 = 'var1c'
SET @var2 = 'var2c'
ELSE
SET @var1 = 'var1other'
SET @var2 = 'var2other'
END
sshcrbum1#
你不能这样休息。把它分成两部分 Case WHEN @TESTVALUE NOT LIKE 'a%' AND @TESTVALUE NOT LIKE 'b%' THEN CASE <rest of the stuff> END END
Case WHEN @TESTVALUE NOT LIKE 'a%' AND @TESTVALUE NOT LIKE 'b%' THEN CASE <rest of the stuff> END END
1条答案
按热度按时间sshcrbum1#
你不能这样休息。
把它分成两部分
Case WHEN @TESTVALUE NOT LIKE 'a%' AND @TESTVALUE NOT LIKE 'b%' THEN CASE <rest of the stuff> END END