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, 2114🔥, 0💬
Popular Posts:
What Happens If the UPDATE Subquery Returns Multiple Rows in SQL Server? If a subquery is used in a ...
Where to find answers to frequently asked questions on Transaction Management: Commit or Rollback in...
How To Recover a Dropped Index in Oracle? If you have the recycle bin feature turned on, dropped ind...
How to change the data type of an existing column with "ALTER TABLE" statements in SQL Server? Somet...
What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...