adspace


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

Answer Posted / Ravi Sanskrityayan

"To modify an existing stored procedure in MS SQL Server, you can use the ALTER PROCEDURE command. Here's an example:nnALTER PROCEDURE <procedure_name> AS...;..."

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I start sql server 2017?

1023


Can we do dml on views?

1041


What kind of problems occurs if we do not implement proper locking strategy?

1508


what is the Ticketing tool used in Wipro technologies at Bangalore...???

8237


Why use identity in sql server?

1209


What is self contained sub query?

1147


What is standby servers? Explain types of standby servers.

1087


What is the difference between upgrade and migration in sql server?

1191


What are the properties of the transaction?

1079


How can we solve concurrency problems?

1129


What is a scheduled job or what is a scheduled task?

1043


How to convert character strings into numeric values?

1196


How can I check that whether automatic statistic update is enabled or not?

1120


Can one drop a column from a table?

1098


What is a view in sql?

1046