use pubs
go
create proc proc_ai
as
select * into ##tem from jobs
go
create proc proc_aii
as
select * from ##tem--run
execute proc_ai
execute proc_aii
go
create proc proc_ai
as
select * into ##tem from jobs
go
create proc proc_aii
as
select * from ##tem--run
execute proc_ai
execute proc_aii
create table ##临时表名(....)