select * from ##tablename

I am executing the below scrip " select * from ##tablename" getting error as :-Invalid object.

How can i access this temporary table

asked Nov 28, 2011 at 02:41 AM in Default

jhunu
110 ● 29 ● 30 ● 35

(comments are locked)

3 answers:

A double # table is a global temporary table, and will cease to exists when all connections have stopped referencing it and the session that created the table has ended.

If you try to access the table outside of these conditions, it will no longer exist.

answered Nov 28, 2011 at 02:45 AM

Kev Riley ♦♦
64k ● 48 ● 61 ● 81

i am accessing in same connection.

Nov 28, 2011 at 03:11 AM jhunu

can you post the script?

Nov 28, 2011 at 03:21 AM Kev Riley ♦♦

(comments are locked)

Check the existence of your global temp table using below query. SELECT * FROM tempdb..sysobjects where name like '%tablename%'

answered Dec 10, 2011 at 01:27 AM

salum
213 ● 2 ● 2

Better to use SELECT OBJECT_ID('tempdb..[##myTempTableName]'). You will receive the correct ID or NULL if table doesn't exists. The like can return multiple objects if you will search a local temp table, but also global with the same name exists or any other table with table name starting as your table exists.

Dec 13, 2011 at 01:15 PM Pavel Pawlowski

(comments are locked)