Reference Manual
   CHAPTER 9. SQL Statements     

EXECUTE statement [T-SQL]

Function 

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

Syntax 

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

Authorization 

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

Side effects 

None.

See also 

CALL statement

Description 

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

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

Example 

• The following demonstration procedure is used to illustrate the EXECUTE statement.

  CREATE PROCEDURE p1( @var INTEGER = 54 )
  AS
  PRINT 'on input @var = %1.', @var
  DECLARE @intvar 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, the PRINT messages are displayed on the client window. If you are connected from an ODBC or Embedded SQL application, the messages are displayed on the database server window.

  EXECUTE p1 23

• The following is an alternative way of executing the procedure, which is useful if there are several parameters.

  EXECUTE p1 @var = 23

• The following statement executes the procedure, using the default value for the parameter

  EXECUTE p1

• The following statement executes the procedure, and stores the return value in a variable for checking return status.

  EXECUTE @status = p1 23