临时表的创建方法及其区别

If object_id(‘temple…#tablename’)
drop table #tablename

–one of two ways
create table #tablename
(
column1 colunmtype,
…
columnN columntype
)

–another
select * into #tablename from tablename (nolock)

–difference
farmer:可以insert语句，往临时表中导数据
latter：insert语句，可能报错