How to see temp table created by code in sql serve ?
create table #temp
create table #temp
(
id int
)
SELECT * FROM
tempdb.dbo.sysobjects O
WHERE O.xtype
in ('U')
AND
O.ID = OBJECT_ID(N'tempdb..#temp')
Name id
#temp_..
-1503307154
No comments:
Post a Comment