A stored procedure can be stored in a text file and run with the Microsoft SQL Server Management Studio.If we are running the code that creates this procedure for the third time,it must start with ________.
A)RUN PROCEDURE
B)CREATE PROCEDURE
C)ALTER PROCEDURE
D)MODIFY PROCEDURE

Question

Quizplus · Accepted Answer

If we are running the code that creates this procedure for the third time, using the "CREATE PROCEDURE" statement will result in an error because the procedure already exists. In this case, we should use the "ALTER PROCEDURE" statement to modify the existing stored procedure.

A Stored Procedure Can Be Stored in a Text File