SQL中CASE控制语句用法

2025-03-01 10:32:42
推荐回答(1个)
回答1:

DECLARE @var int;
CASE @var
WHEN 1 THEN 'var is 1'

WHEN 2 THEN 'var is 2'
ELSE 'var is not 1 or 2' END