Can I have optional parameters to my stored procedures?
Nov 13 '09 at 10:10 AM
Anthony Osborn ♦♦
Apr 21 '10 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 '09 at 10:27 AM
Apr 21 '10 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
asked: Nov 13 '09 at 10:10 AM
Seen: 1012 times
Last Updated: Apr 21 '10 at 05:38 PM
Different data sets in one query
Stored Procedures unit Test?
Optional Parameter or different stored 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 ?
Building a Dynamic Stored Procedure
SSRS 2005 Dataset stored procedure and multi-valued parameter
parameter in stored procedure
optional paramenters in a procedure
Issue with OUTPUT Parameter
Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.Ask SQL Server Central is a community service provided by Red Gate.