Sybase Adaptive Server Anywhere - CREATE PROCEDURE Statement [T-SQL]

CREATE PROCEDURE statement [T-SQL]
460
CREATE PROCEDURE statement [T-SQL]
Use this statement to create a new procedure in the database in a manner
compatible with Adaptive Server Enterprise.
The following subset of the Transact-SQL CREATE PROCEDURE
statement is supported in Adaptive Server Anywhere.
CREATE PROCEDURE [ owner .] procedure_name
…[ [ ( ] @parameter_name data-type [ = default ] [ OUTPUT ], … [ ) ]
]
…[ WITH RECOMPILE ]
…AS
…
statement-list
Must have RESOURCE authority.
Automatic commit.
"CREATE PROCEDURE statement" on page 453
The following differences between Transact-SQL and Adaptive Server
Anywhere statements (Watcom-SQL) are listed to help those writing in both
dialects.
♦
Variable names prefixed by @ The "@" sign denotes a Transact-SQL
variable name, while Watcom-SQL variables can be any valid identifier,
and the @ prefix is optional.
♦
Input and output parameters Watcom-SQL procedure parameters are
specified as IN, OUT, or INOUT, while Transact-SQL procedure
parameters are INPUT parameters by default or can be specified as
OUTPUT. Those parameters that would be declared as INOUT or as
OUT in Adaptive Server Anywhere should be declared with OUTPUT
in Transact-SQL.
♦
Parameter default values Watcom-SQL procedure parameters are
given a default value using the keyword DEFAULT, while Transact-
SQL uses an equality sign (=) to provide the default value.
♦
Returning result sets Watcom-SQL uses a RESULT clause to specify
returned result sets. In Transact-SQL procedures, the column names or
alias names of the first query are returned to the calling environment.
The following Transact-SQL procedure illustrates how result sets are
returned from Transact-SQL stored procedures:
CREATE PROCEDURE showdept @deptname varchar(30)
AS
SELECT employee.emp_lname, employee.emp_fname
FROM department, employee
Function
Syntax
Permissions
Side effects
See also
Description