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

Interactive CSS Button Designer Tool – Free & Fast

What is Button ?                               Button is an element of HTML. HTML is used to design Web Pages, Websites and Web applications...