34,576
社区成员
发帖
与我相关
我的任务
分享
declare @sql varchar(4000)
set @sql = 'select .......into #t........'
set @sql = @sql + ' select * from #t'
exec (@sql)
declare @sql varchar(4000)
set @sql = 'select .......into #t........
...干活区
select * from #t
'
exec (@sql)
declare @sql varchar(4000)
set @sql = 'select .......into ##t........'
exec (@sql)
select * from ##t
select top 0 * into #t from tb
declare @sql varchar(4000)
set @sql = 'insert into #t........'
exec (@sql)
select * from #t
参考:
IF object_id('[tempdb].[dbo].#tmp') IS NOT NULL --判断临时表#tmp是否存在,存在则删除
drop table #tmp
select * into #tmp from tablename where 1=2 --创建临时表#tmp,其结构与tablename相同
declare @QueryString nvarchar(1000) --动态查询语名变量(注:必须为ntext或nchar哐nvarchar类型,不能是varchar类型)
set @QueryString='select * from tablename '
insert into #tmp(field1,field2,...) exec(@querystirng)