How to modify an existing stored procedure in ms sql server?

Question Posted / sanjeev saxena

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

More SQL Server Interview Questions

What are the different types of replication you can set up in sql server?

What is the difference between dropping a database and taking a database offline?

How to create new databases with "create database" statements?

Explain different forms of normalization?

What is the difference between a stored procedure and a user defined function?

Explain error and transaction handling in sql server?

What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?

What is the purpose of UPDATE STATISTICS?

What command is used to delete a table from the database in the sql server and how?

what operator performs pattern matching?

How to set database to be read_only in ms sql server?

Let us say the SQL Server crashed and you are rebuilding the databases including the master database what procedure to you follow?

For more SQL Server Interview Questions Click Here