SQL Server - "CREATE PROCEDURE" - Creating Simple Stored Procedures in SQL Server

If you want to create a simple stored procedure with no input and output parameters, you can use the "CREATE PROCEDURE" command with a statement batch in a simple format as shown in below:

CREATE PROCEDURE procedure_name AS
   statement_1;
   statement_2;
   ...        
   statement_n;
GO

The following tutorial exercise shows you how to create a simple stored procedure:

USE FyiCenterData;
GO            

CREATE PROCEDURE Hello AS
   SELECT 'Welcome to:';
   SELECT '   FYIcenter.com';
GO
Command(s) completed successfully.

EXEC Hello;
GO

-----------
Welcome to;
(1 row(s) affected)

----------------
   FYIcenter.com
(1 row(s) affected)

⇒Using Stored Procedures in SQL Server Transact-SQL

⇒⇒SQL Server Transact-SQL Tutorials

2017-01-05, 816👍, 0💬