一句无法解释的SQL语句,不知道是不是微软的Bug

select (select top 1 (select username from [192.168.0.12].[popauto].dbo.admin with(nolock) where id=d.power)+resion
         from dl_log_isdel as d with(nolock) where muserid=dl_muser.id and state=2 order by id desc) as delresion,
        (select top 1 (select username from admin where id=d.power)+resion from dl_log_isdel as d with(nolock)
typename=case cclass when 1 then '4S' else '综合' end, cclass,address,'' as fct2name,
isdel, ishy,isvip,paya,payb,payc,star from dbo.dl_muser with(nolock) where isdel=0 and isxx=0

 

如上上一句SQL语句,在sql server 2005里边运行失败,不知道是不是微软的bug  跨库查出出来的两列相加出错

posted on 2008-08-06 09:25  neil-zhao  阅读(214)  评论(0编辑  收藏  举报

导航