Setting the Add Parameter dialog box options
The Add Parameter dialog box lets you define parameters contained in a SQL statement by entering the parameters name and default value (the value the parameter should take if no runtime value is returned).
To define SQL parameters:
- Select a parameter name from the Name pop-up menu.
- Enter a default value for the parameter in the Default Parameter text box.
The default value is the value the parameter should use if no runtime value is returned.
- Click OK.
Related Topics
- Using stored procedures to modify databases (ASP.NET)
- Setting the Stored Procedure dialog box options (ASP.NET)
- Retrieving form and URL parameters.