帮忙修改一条语句
我的存储过程中有这样一条,引号加的不对
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
好象没错