Monday, 3 October 2016

How to see temp table created by code in sql server?


How to see temp table created by code in sql serve ?
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

Python Tutorial: Conditional Statements

Python Tutorial: Conditional Statements Python is a smart language , compare to other programing language python code is so smart that it ma...