获取临时表的列名
程序员文章站
2022-03-10 14:54:43
...
获取临时表的列名 无 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');