How can we create a global temporary table?

 Posted by Rajni.Shekhar on 4/17/2012 | Category: Sql Server Interview questions | Views: 1512 | Points: 40

Using ## with table name, we can create a global temporary table.

CREATE TABLE ##globalTempTable 

id INT,
name VARCHAR(50)

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response