获取临时表的列名
- WBOYOriginal
- 2016-06-07 14:57:061622browse
获取临时表的列名 无 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');
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：用于监控数据库情况Next article：SQLServer添加链接服务器