Export (0) Print
Expand All

Specifying Parameters

A stored procedure communicates with the calling program through its parameters. When a program executes a stored procedure, it can pass values to the stored procedure through the parameters of the stored procedure. These values can be used as standard variables in the Transact-SQL programming language. The stored procedure can also return values to the calling program through OUTPUT parameters. A stored procedure can have as many as 2100 parameters, with each parameter having a name, data type, direction, and default value.

Topic Description

Specifying a Parameter Name

Describes how to name parameters.

Specifying a Parameter Data Type

Describes the data types that can be assigned to stored procedure parameters.

Specifying the Direction of a Parameter

Describes input and output parameters.

Specifying a Parameter Default Value

Describes how default values can be specified for parameters.

Community Additions

ADD
Show:
© 2014 Microsoft