When you use the Microsoft SQL Server Management Studio to run and rerun a set of SQL Server DBMS commands stored in a text file,the stored procedure must start with CREATE PROCEDURE.

Question

Quizplus · Accepted Answer

The stored procedure does not necessarily have to start with CREATE PROCEDURE when running a set of SQL Server DBMS commands stored in a text file using Microsoft SQL Server Management Studio. The text file could contain any valid T-SQL statements, including but not limited to creating stored procedures.

When You Use the Microsoft SQL Server Management Studio to Run