日期:2014-05-19  浏览次数:20452 次

这个SQL对吗 convert
update   Userinfo   set   huiyuan= '000000 '   where     Convert(bigint,accounts) <=88800011   and   Convert(bigint,accounts> =88800010
accounts   是char   型



------解决方案--------------------
--try

update Userinfo set huiyuan= '000000 ' where
Convert(bigint,rtrim(ltrim(accounts))) between 88800010 and 88800011

------解决方案--------------------
accounts中必须是纯数字的字符串.
------解决方案--------------------
update Userinfo set huiyuan= '000000 ' where isnull(accounts, ' ')between '88800010 ' and '88800011 '

刚才反过来了

------解决方案--------------------
字段上最好加上约束。