Showing posts with label How to see temp table created by code in sql serve. Show all posts
Showing posts with label How to see temp table created by code in sql serve. Show all posts

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

Python Tutorial : Loop

Python Tutorial : Loop                          Python is one of the popular language programming language , Python are very popular since 1...