日期:2014-05-17  浏览次数:20567 次

请问如何insert的时候插入百分号
请问我要插入一条语句
SQL code
insert into final exec('select value  from store_temp where number = '+@colnumber+' - 1')
如何才能把百分号一同插入

------解决方案--------------------
SQL code
insert into final 
select ltrim(value)+'%' from store_temp where number =@colnumber-1

------解决方案--------------------
SQL code
insert into final exec('select rtrim(value)+''%''  from store_temp where number = '+@colnumber+' - 1')

------解决方案--------------------
SQL code
--try
insert into final exec('select value+''%''  from store_temp where number = '+@colnumber+' - 1')

------解决方案--------------------
什么地方涉及到了百分号?