存储过程中引号的问题 急....

[ghostdomgu]

在存储过程中有这样一句
select @sql = 'select top @sum phone, send_time from t_web_user where phone like '%@phone%'order by send_time desc'


其中'%@phone%'该怎么写??

[playwarcraft]

其中'%@phone%'该怎么写??
----------------------------------------
''%@phone%''

[playwarcraft]

兩單引號

[xyxfly]

select @sql = 'select top @sum phone, send_time from t_web_user where phone like '%@phone%'order by send_time desc'
---->
select @sql = 'select top '+@sum+' phone, send_time from t_web_user where phone like ''%'+@phone+'%''order by send_time desc'

[xyxfly]

两个变量那里也有问题哦

[longji]

create proc test
as
begin
declare @sql varchar(5000)
declare @phone varchar(100)
declare @sum int
set @sql = ''
set @phone=''
set @sum=1
select @sql = 'select top ' + convert(varchar,@sum) + ' phone, send_time from t_web_user where phone like % ' + @phone + '% order by send_time desc'

end

[xyxfly]

寒一下　@sum----->rtrim(@sum)