存储过程

if (select object_ID('tempdb..#BaseInfoFK')) >0 drop table #BaseInfoFK
select a.* into #BaseInfoFK from (select * from table)a#BaseInfoFK是临时表的名一定要加#

原文地址:https://www.cnblogs.com/wl-blog/p/15439560.html