Collections:
EXECUTE - Executing Stored Procedures in SQL Server
How To Execute a Stored Procedure in SQL Server Transact-SQL?
✍: FYIcenter.com
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
2017-01-05, 2213🔥, 0💬
Popular Posts:
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...
What Is an Oracle Tablespace in Oracle? An Oracle tablespace is a big unit of logical storage in an ...
How To List All Login Names on the Server in SQL Server? If you want to see a list of all login name...
How To Calculate DATETIME Value Differences Using the DATEDIFF() Function in SQL Server Transact-SQL...
How To Drop an Index in Oracle? If you don't need an existing index any more, you should delete it w...