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: Conditional Statements

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