EXECUTE statement [T-SQL]

Description

Invokes a procedure, as an Adaptive Server Enterprise-compatible alternative to the CALL statement.

Syntax

EXECUTE [ @return_status = ] [owner.]procedure_name
... { [ @parameter-name = ] expression
| [ @parameter-name = ] @variable [ output ] } ,...

Examples

Example 1

• Illustrates the EXECUTE statement:

CREATE PROCEDURE p1( @var INTEGER = 54 )
AS
PRINT 'on input @var = %1! ', @var
DECLARE @internal_var integer
SELECT @intvar=123
SELECT @var=@intvar
PRINT 'on exit @var = %1!', @var

• The following statement executes the procedure, supplying the input value of 23 for the parameter. If you are connected from an Open Client application, PRINT messages are displayed on the client window. If you are connected from an ODBC or Embedded SQL application, messages display on the database server window.

EXECUTE p1 23

• An alternative way of executing the procedure, which is useful if there are several parameters:

EXECUTE p1 @var = 23

• Executes the procedure, using the default value for the parameter:

EXECUTE p1

• Executes the procedure, and stores the return value in a variable for checking return status:

EXECUTE @status = p1 23

Usage

EXECUTE executes a stored procedure, optionally supplying procedure parameters and retrieving output values and return status information.

EXECUTE is implemented for Transact-SQL compatibility, but can be used in either Transact-SQL or Sybase IQ batches and procedures.

None.

Permissions

Must be the owner of the procedure, have EXECUTE permission for the procedure, or have DBA authority.

See also