Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-03-01 : 00:28:36
|
Giovanni writes "We have a stored proc. with a few parameters. Some are mandatory and will always get a value passed to them while some are optional. In addition these parameters have to be used in a WHERE clause to select the correct amount of information. Simply put, the question is as follows:
If I specify a value for the parameter then it should narrow down its resultset to that, if no parameter value is specified, then it should return all records. Remember, the optional parameters will be part of an SQL WHERE clause." |
|
|
|
|
|
Optional Parameters