存储过程写临时表

存储过程写临时表

1.创建临时表

create table #cursor
(
   Id int,
   Name varchar
   
);

2.把查询到的数据添加进去，注意属性要一样。

insert into  #cursor
select * FROM [dbo].[biaoming]  

insert into  #cursor
select Id,Name FROM [dbo].[biaoming2]  

总体：

CREATE PROCEDURE [dbo].[Pdb_Excunchuguocheng]
    @RiJieRiQi datetime    
AS
create table #cursor
(
   Id int,
   Name varchar
);
insert into  #cursor
select * FROM [dbo].[biaoming]  

insert into  #cursor
select Id,Name FROM [dbo].[biaoming2]  

select * from #cursor
GO

查询：

exec [dbo].[Pdb_Excunchuguocheng]

 如果想添加与表无关联的数据，可以创建一个临时表在对主表修改

select * into #a from [dbo].[waijiashujubiao] 

  update #cursor set Name= #a.Name  from #a