DB2 转化成SQL SERVER

显示全部楼层 · 2005-10-30 17:05:33

如何将下列语句转化成SQL SERVER
with c(temp_qybm,qybm,sjqy) as
(select qybm,qybm,(case when ((sjqy is null) or (sjqy='')) then qybm else sjqy end) from t_qy where
qybm in (select qybm from t_jgxx)
union all
select c.temp_qybm,t.qybm,t.sjqy from t_qy t,c where
c.qybm=t.sjqy)
select temp_qybm,qybm,cast(0 as integer) from c

千问 · 2005-10-30 17:05:33

有高手知道怎么做吗

千问 · 2005-10-30 17:05:33

select qybm,qybm,(case when ((sjqy is null) or (sjqy='')) then qybm else sjqy end) into c
from t_qy where qybm in (select qybm from t_jgxx)
select * from c
union all
select c.temp_qybm,t.qybm,t.sjqy from t_qy t,c where
c.qybm=t.sjqy
select temp_qybm,qybm,cast(0 as integer) from c