摘要:
若b列的值都为1则返回Y,否则返回X declare @t table(a int,b int)insert @tselect 1,1 union all select 2,1 union all select 3,1 union all select 4,0 select b=case when exists(select b from @t where b1) then 'X' else 'Y... 阅读全文
posted @ 2006-11-09 11:45
StephenJu
阅读(543)
评论(0)
推荐(0)

浙公网安备 33010602011771号