Output parameters
You can use output parameters to get the values back to the caller of the procedure using OUT or OUTPUT keyword with the parameter.
@dtmRegDate test.datetime OUT
Assign a default value to a parameter
If you are not passing a value as an argument this value will be set.
Table valued parameters
You can define a table data type and pass an argument of that type (table with some data) to a stored procedure
@dtmRegDate datetime = '1/2/2011',
No comments:
Post a Comment