Export (0) Print
Expand All
3 out of 3 rated this helpful - Rate this topic

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.

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.


Creating Stored Procedures (Database Engine)
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2014 Microsoft. All rights reserved.