select * into #b from GOODSDOC //自动创建一个临时表#b
insert into #b select top 10 * from GOODSDOC where GoodsCode like '%W%' //在已有的临时表中插入数据
select * from #b
delete from #b
drop table #b
insert into #b select top 10 * from GOODSDOC where GoodsCode like '%W%' //在已有的临时表中插入数据
select * from #b
delete from #b
drop table #b