34,593
社区成员
发帖
与我相关
我的任务
分享
use tempdb
go
declare @a int
set @a=1
select case @a
when 1 then print 'a'
else print 'b'
end
declare @a int
set @a=1
print (case when @a = 1 then 'a' else 'b' end)
declare @a int
set @a=1
print(case @a when 1 then 'a' else 'b' end)
DECLARE @TEST VARCHAR(50)
SET @TEST=2
IF(@TEST=1)
SELECT * FROM GoodsChecks
ELSE IF(@TEST=2)
SELECT * FROM WarehouseOnShelfLists
ELSE
SELECT * FROM PurchaseReturnedGoods
declare @a int
set @a=1
declare @sql varchar(500)
if @a=1 set @sql='select 0'
else set @sql='select 1'
exec @sql
declare @a int
set @a=1
select case when @a=1 then 'a' else 'b' end