获取临时表的列名

获取临时表的列名 无 create table #SomeTmpTbl(col1 int,col2 varchar(20),col3 datetime)GOselect * from tempdb.sys.columns where object_id =object_id('tempdb..#SomeTmpTbl');

获取临时表的列名

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

GO

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