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 - 2004-01-30 : 07:17:56
|
| santanu writes "is there any way so that i can pass multiple number of parameter to a store proc depending upon the situiation.i will call the same procedure but sometime i will pass 1 parameter,sometime 2 or 3 or4 .....please advice" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-01-30 : 07:27:18
|
| If you have a max number of parameters then you can make them optional by giving a default.Otherwise use a csv string or a temp table.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
store proc