Friday, August 26, 2011

Parameter options for SQL stored procedures

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',

1 comment:

  1. Thanks for such a nice and updated information. I got some interesting tips from this post.
    Sony Laptops