How to end a stored procedure properly in ms sql server?


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

Post New Answer

More SQL Server Interview Questions

Can you explain full-text query in sql server?

0 Answers  


SQL stops working in every 15 days displaying message that database log file is full. Log file size is 3.95 GB. It is happening after shrinking the database also. What is solution to overcome this problem. Please help me as it's urgent.

5 Answers  


What is the purpose of using COLLATE in a query?

1 Answers  


What is a periodical index?

0 Answers  


What are the different types of replication? How are they used?

3 Answers  


Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?

2 Answers  


What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?

1 Answers  


what is database replication? : Sql server database administration

0 Answers  


You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?

0 Answers  


What is it unwise to create wide clustered index keys?

0 Answers  


Explain what are various ways to enhance the ssrs report?

0 Answers  


What is deadlock and how to avoid the deadlocks.

3 Answers   TCS, Wipro,


Categories