内存储器表临时表

内存表临时表

create table #aaa (a char(1))     insert #aaa values ('1')         SELECT *  FROM #aaa     SELECT *   into   #aaa   from   BASE_AUTH           declare @aaa table (a char(1))     insert into @aaa select * from #aaa     SELECT *  FROM @aaa    drop table #aaainsert into @aaa (a) values('2')