获取临时表的列名

清华大佬耗费三个月吐血整理的几百G的资源,免费分享!....>>>

create table #SomeTmpTbl
(
col1 int,
col2 varchar(20),
col3 datetime
)

GO

select * from tempdb.sys.columns where object_id =
object_id('tempdb..#SomeTmpTbl');