求高手!急!!!!!两条access改sqlserver!

[复制链接]
查看11 | 回复0 | 2011-3-5 06:33:22 | 显示全部楼层 |阅读模式
string cmd = \" select *,(select top 1 uspianfrom UserInfo where usname=wbupren) asdcliang,(selectsum(ydshuliang)from YingDanwhereWangBaInfo.wbid=YingDan.ydinfoid \" tj2 \" ) as xsydshuliang,(selectsum(ydshuliang)from YingDanwhere YingDan.ydinfoid =0\" tj2
\" ) as xsydshuliang2 from WangBaInfo \" tj \"order by wbid desc



select top 1((select count(wbid)*0.1from WangBaInfowhere wbupren =\'\" name \"\' and wbjianboss=true) (select count(wbid)*0.3from WangBaInfowhere wbupren =\'\" name \"\' and wbsongji=true) (select count(wbid)*0.6from WangBaInfowhere wbupren =\'\" name \"\' and wbsfhetong=true) (select count(wbid)*0.9from WangBaInfowhere wbupren =\'\" name \"\' and wbsfdingjin=true)) as \'fen\',wbid fromWangBaInfo

这两句中有什么地方不适合做sqlserver查询呢?要怎么改???!!!!!
劳驾高手!
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

主题

0

回帖

4882万

积分

论坛元老

Rank: 8Rank: 8

积分
48824836
热门排行