读书人

为什么这句SQL出错解决思路

发布时间: 2012-01-12 22:11:58 作者: rapoo

为什么这句SQL出错
exec( 'update xsyjtotalyku_1_admin set ysbl=ltrim(rtrim(cast(cast(100*ysje/xsje as decimal(18,2)) as char(10)))) '+ ' '% ' ')

[解决办法]
exec( 'update xsyjtotalyku_1_admin set ysbl=ltrim(rtrim(cast(cast(100*ysje/xsje as decimal(18,2)) as char(10))))+ ' '% ' ' ')

读书人网 >SQL Server

热点推荐