How to modify an existing stored procedure 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

What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?

0 Answers  


What is a field name?

0 Answers  


What is the security principal at the database level that represents your session?

0 Answers  


We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?

0 Answers   Amdocs, Apps Associates,


What are the functions in sql server?

0 Answers  






Why functions are used in sql server?

0 Answers  


What is serializable?

0 Answers  


What is difference beteen Migration and Upgrdation?

7 Answers   Satyam,


1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

0 Answers  


Can we write a distributed query and get some data which is located on other server and oracle database?

0 Answers  


What is difference between commit and rollback when used in transactions?

0 Answers  


How do indexes help, types?

0 Answers  


Categories