Differentiate between a Local and a Global temporary table?

 Posted by vishalneeraj-24503 on 10/7/2014 | Category: Sql Server Interview questions | Views: 307 | Points: 40
Answer:

1). A Local temporary table exists only for the duration of a connection or,if defined inside a compound statement,for the duration of the compound statement.

2). Global temporary tables created with a double "##" are visible to all sessions.

3). Global temporary tables are dropped when the session that created it ends,and all other sessions have stopped referencing it.


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response