declare @strBar varchar(20)
declare @strSql varchar(2000)
declare @shopno varchar(20)
set @shopno=''特殊''
set @strBar='43'
set @strBar=@strBar + '.xls'
set @strSql = 'select * from EtamShop where name='+@shopno
select @strSql
declare @strSql varchar(2000)
declare @shopno varchar(20)
set @shopno=''特殊''
set @strBar='43'
set @strBar=@strBar + '.xls'
set @strSql = 'select * from EtamShop where name='+@shopno
select @strSql
declare @strSql varchar(2000)
declare @shopno varchar(20)
set @shopno='特殊'
set @strBar='43'
set @strBar=@strBar + '.xls'
set @strSql = 'select * from EtamShop where name='''+@shopno+''''
select @strSql
declare @strSql varchar(2000)
declare @shopno varchar(20)
set @shopno='id'
set @strBar='43'
set @strBar=@strBar + '.xls'
exec('select * from cc where name='+@shopno)
我不要执行这命令,我是作为一个变量,传到别的地方