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-08-09 : 09:24:27
|
| Balajee writes "I am Using SQL Server 7.0, Win 2000 ServerI have comma delimited SQL text passed as Parameters to a stored procedure. I am usingconnection object to execute the stored procedure. While passing the parameterspositionally will i be able to leavecertain parameters take default valuesFor Example while executing the Proceduresp_MyProc i need to pass four parameters.i would only need to pass the 2nd and 4thparameter, remaining parameters takes default valuesThe Call to Procedure should look likeConn.sp_MyProc [param1],[param1],[param1],[param1]Here param1 and param3 are not passed to SQL serverthey must take default values. Is such thing possiblewhen passing parameters this way." |
|
|
|
|
|
Passing Null Parameters to stored Procedures