Explain what is the difference between a local and a global temporary table?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

can a table be moved to different filegroup? : Sql server administration

0 Answers  


hi. suppose one person goal is strong knowledge on SQL.... suggest me ...if he learns SQL SERVER or ORACLE? which is best?

7 Answers   Google, TCS, Unisys,


In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

0 Answers  


Does sql server use t sql?

0 Answers  


What happens to a trigger with multiple affected rows?

0 Answers  






i want to join two queries....and i want to run them as one after another that is want output of first query then second , then again output of first query then second and so on...

2 Answers  


Why variables called the most powerful component of ssis?

0 Answers  


What is conditional split?

0 Answers  


hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.

0 Answers  


Questions regarding Raiseerror?

1 Answers  


What is query optimization process?

0 Answers  


How do indexes help, types?

0 Answers  


Categories