一点语法的小问题
我的一个执行存储过程的语句,用char(39)代替字符串两边的单引号,怎么通不过呀
declare @s float
exec a char(39)+ccode like ' '5% ' '+char(39),5,2006, 'i ',@s output
select @s
帮忙看看吧,郁闷呀
------解决方案----------------------try
declare @s float
exec a 'ccode like ' '5% ' ' ',5,2006, 'i ',@s output
select @s
------解决方案----------------------try
declare @s float
exec a char(39)+ 'ccode like ' '5% ' ' '+char(39),5,2006, 'i ',@s output
select @s