Can I have optional parameters to my stored procedures?
Nov 13, 2009 at 10:10 AM
Anthony Osborn ♦♦
Apr 21, 2010 at 05:38 PM
Kev Riley ♦♦
You haven't provided much detail , but this is how you can default parameter values (and therefore make them optional)
Create Procedure proc @Param1 integer = NULL
Nov 13, 2009 at 10:27 AM
Apr 21, 2010 at 09:12 PM
Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.
Once you sign in you will be able to subscribe for any updates here
Answers and Comments
Need long-form SQL discussion? SQLserverCentral.com is the place.
asked: Nov 13, 2009 at 10:10 AM
Seen: 2197 times
Last Updated: Apr 21, 2010 at 05:38 PM
Multiple Valued Stored Procedure
Stored Procedures unit Test?
How To Build Dynamic Query Based On Multi Value Parameter?
Optional Parameter or different stored procedure?
table value parameters with stored procedure
Avoid implicit conversion in procedure params
Must declare the scalar variable @edate
optional paramenters in a procedure
different ways to use parameterized TOP statement, but which one is the best?
How to get the count of Input Parameters and their names in SP ?