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 |
|
delpiero
Yak Posting Veteran
98 Posts |
 Posted - 2005-03-15 : 02:35:45
|
| Hi all, Suppose I have a stored procedure with 8 input parameters, each with a default value specified. What is the most common method to call the stored procedures with some or all parameters left to the default? e.g. using the DEFAULT keyword ... It seems tedious to type in the keyword DEFAULT for every parameter if I have a lot of them. Is there any other method?Thanks,delpiero |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-03-15 : 03:01:11
|
quote:
Originally posted by delpiero
Hi all, Suppose I have a stored procedure with 8 input parameters, each with a default value specified. What is the most common method to call the stored procedures with some or all parameters left to the default? e.g. using the DEFAULT keyword ... It seems tedious to type in the keyword DEFAULT for every parameter if I have a lot of them. Is there any other method?Thanks,delpiero
include the parameter name in executing the sp..exec spName @var1=value1,@var4=value...--------------------keeping it simple... |
 |
|
|
|
|
|
Calling stored procedures with default parameters