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

帮忙修改一条语句
我的存储过程中有这样一条,引号加的不对

set   @insertstring   =  
'select   *   into   '   +   @city   +
'   from     table     where   companies   like   ' '% '   +   @city+   '% ' ' '

请各位帮帮忙

------解决方案--------------------
declare @insertstring varchar(1000)
declare @city varchar(1000)
set @city= '武汉 '
set @insertstring =
'select * into ' + @city +
' from table where companies like ' '% ' + @city+ '% ' ' '
print @insertstring
好象没错