日期:2014-05-16  浏览次数:20486 次

内存表临时表
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 #aaa

insert into @aaa (a) values('2')