State the difference between local and global temporary tables?
No Answer is Posted For this Question
Be the First to Post Answer
How to create a simple user defined function in ms sql server?
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
How data can be copied from one table to another table?
Explain subquery and state its properties?
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.
What is store procedure? How do they work?
What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?
Explain what are sparse columns?
can you any body tell me simple recovery,full recovery,bulk logged recovery where can use?
What stored by the msdb?
Can one drop a column from a table?
Difference between Function and Procedure-in general?