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)STORED PROCEDURE
B)CREATE PROCEDURE
C)ALTER PROCEDURE
D)MODIFY PROCEDURE
E)RUN PROCEDURE

Question

Quizplus · Accepted Answer

If we are running the code that creates this procedure for the third time, we need to modify the existing procedure. In SQL Server, we can modify an existing stored procedure using the ALTER PROCEDURE statement. Using the CREATE PROCEDURE statement again will result in an error saying the stored procedure already exists. Therefore, the correct choice is C) ALTER PROCEDURE.

A Stored Procedure Can Be Stored in a Text File