use pubs go declare @tbl varchar(20) set @tbl='authors' exec('select top 1 * from '+@tbl) 结果: au_id au_lname au_fname phone address city state zip contract ----------- ---------------------------------------- -------------------- ------------ ---------------------------------------- -------------------- ----- ----- -------- 172-32-1176 White Johnson 408-496-7223 10932 Bigge Rd. Menlo Park CA 94025 1
@temp_talbe varchar(50)
as
exec('select * from '+ @temp_table)
as
declare @temp_talbe varchar(50)
select * from @temp_talbe
我想这样可以吗
@temp_talbe varchar(2000)
asdeclare @sql varchar(2000) --定义一个字符串变量set @sql='select * from ' + @temp_tableexec (@sql) --执行动态sql语句
go
declare @tbl varchar(20)
set @tbl='authors'
exec('select top 1 * from '+@tbl)
结果:
au_id au_lname au_fname phone address city state zip contract
----------- ---------------------------------------- -------------------- ------------ ---------------------------------------- -------------------- ----- ----- --------
172-32-1176 White Johnson 408-496-7223 10932 Bigge Rd. Menlo Park CA 94025 1