select a.* from tempdb.sys.columns a
inner join tempdb.sys.objects b
on a.[object_id]=b.[object_id] and b.type='u'
where b.name LIKE '#DataList%'
查看临时表结构
最新推荐文章于 2021-02-03 02:42:07 发布
select a.* from tempdb.sys.columns a
inner join tempdb.sys.objects b
on a.[object_id]=b.[object_id] and b.type='u'
where b.name LIKE '#DataList%'