General MySQL Oracle SQL Server

EXECUTE - Executing Stored Procedures in SQL Server

Q

How To Execute a Stored Procedure in SQL Server Transact-SQL?

✍: FYIcenter.com

A

If you want execute a stored procedure created previously, you can use the EXECUTE statement in the following formats: 

EXEC procedure_name;
EXECUTE procedure_name;

The key word EXEC is actually optional. So you can execute a stored procedure by just entering the procedure name as the statement. See examples in the following tutorial exercise: 

USE FyiCenterData;
GO

-- create a quick procedure 
CREATE PROCEDURE date AS 
   PRINT CONVERT(VARCHAR(20),GETDATE(),107);
GO

-- execute with EXEC
EXEC date;
GO
May 19, 2007

-- execute with EXEC
date;
GO
May 19, 2007


-- using a reserved keyword as procedure name
CREATE PROCEDURE datetime AS PRINT GETDATE();
GO

datetime;
GO
May 19, 2007 11:35PM

Looks like SQL Server allows you to reserved keywords as stored procedure names.

 

⇒ sys.procedures - Listing All Stored Procedures in SQL Server

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

⇑ Using Stored Procedures in SQL Server Transact-SQL

⇑⇑ SQL Server Transact-SQL Tutorials

2017-01-05, 3180🔥, 0💬

General MySQL Oracle SQL Server