drop table #t
go
create table #t(spid int,ecid int,status varchar(20),loginname varchar(50),hostname varchar(50),blk int,dbname varchar(20),cmd varchar(255))
insert into #t
exec sp_who 'active'select * from #t
go
create table #t(spid int,ecid int,status varchar(20),loginname varchar(50),hostname varchar(50),blk int,dbname varchar(20),cmd varchar(255))
insert into #t
exec sp_who 'active'select * from #t
我用的是select into #t 结果报错
drop table #t
select into #t....
这样就可以了
if object_id('#t') is not null
drop table #t
go
select * into #t from (exec sp_who 'active')
--这样子会报错,别看头不看尾呀