22,293
社区成员
发帖
与我相关
我的任务
分享
declare @parent varchar(200),@table varchar(2000)
set @table='xiaoqu_manage'
set @sqls='select @a=Path from ' + @table + ' where id = 2'
exec sp_executesql @sqls,N'@a varchar(200) output',@parent output
select @parent
declare @parent varchar(200),@table varchar(2000) ,@sql nvarchar(4000)
set @table='xiaoqu_manage'
set @sql = N'select @parent=Path from '+@table+' where ID=2'
exec sp_excutesql @sql,N'@parent varchar(2000) output',@parent out
select @parent
declare @parent varchar(200),@table varchar(2000)
set @table='xiaoqu_manage'
exec('select @parent=Path from '+@table+' where ID=2')
declare @parent varchar(200),@table varchar(2000),@s nvarchar(4000)
set @table='xiaoqu_manage'
set @s=N'select @a=Path from ' + @table + ' where id = 2'
exec sp_executesql @s,N'@a varchar(200) output',@parent output
select @parent
SOYYR,没看到里面的变量,更正.declare @parent varchar(200),@table varchar(2000)
set @table='xiaoqu_manage'
--------------------------------------------------------------
declare @sqlstring nvarchar(1000)
set @sqlstring=N'select @parent=Path from '+@table+' where ID=2 '
exec sp_executesql @sqlstring,N'@parent varchar(200) output',@parent output
select @parent
--------------------------------------------------------------
declare @parent varchar(200),@table varchar(2000)
set @table='xiaoqu_manage'
--------------------------------------------------------------
declare @sqlstring nvarchar(1000)
set @sqlstring=N'select @parent=Path from '+@table+' where ID=2 '
exec sp_executesql @sqlstring,N'@parent varchar(200) output',@parent output
select @parent
--------------------------------------------------------------