动态表名如何写 exec ('select * from ' +@table) 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 declare @parent varchar(200),@table varchar(2000) set @table='xiaoqu_manage' exec('select @parent=Path from '+@table+' where ID=2') exec('select * from '+@table) 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 outselect @parent sp_excutesql - > sp_executesqlsorry 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) 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 outputselect @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 outputselect @parent-------------------------------------------------------------- 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 @parentSOYYR,没看到里面的变量,更正. 设置Select fieldA 值为空 新手求教:删除表内记录 请教个sql语句的问题.... 求一sql语句? 问个关于存贮过程的问题 help!!!!!!!!!!!再发一次,难道就没人会写吗?? 请教一句SQL语句的写法!谢谢! 如何看游标里有什么记录 如何在sql server 中插入.wav的声音文件,帮忙! 请教查询语句? 关于一个SQL语句速度的问题 sql2005数据库修改问题
set @table='xiaoqu_manage' exec('select @parent=Path from '+@table+' where ID=2')
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 outselect @parent
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
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
--------------------------------------------------------------
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),@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 @parentSOYYR,没看到里面的变量,更正.