case 正确写法问题
declare @type as int
set @type=3
由
SELECT
CASE @type
WHEN 1 THEN 'A '
WHEN 2 THEN 'B '
WHEN 3 THEN 'C '
WHEN 4 THEN 'A '
WHEN 5 THEN 'B '
WHEN 6 THEN 'A '
END
如何简写为这种效果?
SELECT
CASE @type
WHEN 1,4,6 THEN 'A '
WHEN 2,5 THEN 'B '
WHEN 3 THEN 'C '
END
[解决办法]
SELECT
CASE
WHEN @type in(1,4,6) THEN 'A '
WHEN @type in(2,5) THEN 'B '
WHEN @type in(3) THEN 'C '
END
case 正确写法有关问题
case 正确写法问题declare@typeasintset@type3由SELECTCASE@typeWHEN1THENAWHEN2THENBWHEN3THENCWHEN4THE
