SQL Server FAQ - EXECUTE - Executing Stored Procedures

Home >> FAQs/Tutorials >> SQL Server FAQ

By: FYIcenter.com

How To Execute a Stored Procedure?

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.

(Continued on next topic...)