34,590
社区成员
发帖
与我相关
我的任务
分享为什么这句SQL出错
exec('update xsyjtotalyku_1_admin set ysbl=ltrim(rtrim(cast(cast(100*ysje/xsje as decimal(18,2)) as char(10))))'+''%'')
...全文
请发表友善的回复…
发表回复
wgzaaa 2007-08-15
- 打赏
- 举报
print 出来查错
print('update xsyjtotalyku_1_admin set ysbl=ltrim(rtrim(cast(cast(100*ysje/xsje as decimal(18,2)) as char(10))))'+'+''%''')
print('update xsyjtotalyku_1_admin set ysbl=ltrim(rtrim(cast(cast(100*ysje/xsje as decimal(18,2)) as char(10))))'+'+''%''')
longlongBing 2007-08-15
- 打赏
- 举报
exec('update xsyjtotalyku_1_admin set ysbl=ltrim(rtrim(cast(cast(100*ysje/xsje as decimal(18,2)) as char(10))))+''%''')
kk19840210 2007-08-15
- 打赏
- 举报
exec('update xsyjtotalyku_1_admin set ysbl=ltrim(rtrim(cast(cast(100*ysje/xsje as decimal(18,2)) as char(10))))')
wgzaaa 2007-08-15
- 打赏
- 举报
sorry,楼上是对的，我的画蛇添足了
