Can I have optional parameters to my stored procedures?
Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.
Answer by dave ballantyne · Nov 13, 2009 at 10:27 AM
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
Answers Answers and Comments
No one has followed this question yet.
how to batch insert using proc?
Multiple Valued Stored Procedure
Create a dynamic Where clause based on Parms from report services
How To Build Dynamic Query Based On Multi Value Parameter?
Avoid implicit conversion in procedure params