State the difference between local and global temporary tables?


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

Post New Answer

More SQL Server Interview Questions

How to create a simple user defined function in ms sql server?

0 Answers  


you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation

0 Answers  


How data can be copied from one table to another table?

0 Answers  


Explain subquery and state its properties?

0 Answers  


How to handle errors in Stored Procedures. I want to display a message to the user in the .aspx page that is calling a stored procedure in it's code behind. please help me.

2 Answers   247Customer,






What is store procedure? How do they work?

0 Answers  


What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

1 Answers  


Explain what are sparse columns?

0 Answers  


can you any body tell me simple recovery,full recovery,bulk logged recovery where can use?

1 Answers  


What stored by the msdb?

0 Answers  


Can one drop a column from a table?

0 Answers  


Difference between Function and Procedure-in general?

6 Answers  


Categories