一个在acsess中执行得sql语句无法在mssql中执行 询问解决方案

[ayun00]

SELECT detail, count, cstr(cint((count/iif((select sum(count) from diaoc_m where voteid=2)=0,1,(select sum(count) from diaoc_m where voteid=2)))*10000)/100)+'%' AS precount FROM diaoc_m WHERE voteid=2

[子陌红尘]

将iif()用case when 替换
将cstr，cint用cast()替换

[didoleo]

SELECT detail,count,cast(cast((count/case when (select sum(count) from diaoc_m where voteid=2)=0 then 1 else (select sum(count) from diaoc_m where voteid=2))*10000 as int)/100 as varchar)+'%' AS precount FROM diaoc_m WHERE voteid=2

[ayun00]

还是报错啊
是不是语句本身有错那>?

[ayun00]

语句还是有错啊

[lxysjl]

把count用[]括起来,是关键字来的.

[ayun00]

也试过了