Getting Started with Adobe After Effects - Part 6: Motion Blur
This module helps you to share, discuss and learn interview questions and answers of different technologies

Global temporary table in SQL Server

Feb 21 2012 12:00AM by Vivek Johari   

Question

What are the global table in SQL Server

Answer

Global temporary table is created in the tempdb and it is visible to all the sessions . Global temporary tables are only destroyed when the current user disconnected and all the sessions referring to it closed. It means no user sessions refers it. Since the global temporary table is created in the tempdb, whenever we use temporary tables there is a interaction between the two database (tempdb and the database in which block of code is written) which may slow down the performance. Global temporary table can be used in Joins. Global table is created with the help of the ##.

The syntax for creating the global temporary table is given below:

create table ##[table name] (col1 datatype, col2 datatype, ......coln datatype)

Read More..   [43 clicks]

Published under: SQL Server Interview Questions ·  ·  ·  · 


Vivek Johari
116 · 1% · 445
0
Liked
 
0
Asked



Submit

Your Comment


Sign Up or Login to post a comment.

"Global temporary table in SQL Server" rated 5 out of 5 by 4 readers
Global temporary table in SQL Server , 5.0 out of 5 based on 4 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]