时间:2021-07-01 10:21:17 帮助过:16人阅读
获取临时表的列名 无 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');