x

login about faq Site discussion (meta-askssc)

Can I have optional parameters to my stored procedures?

0

Can I have optional parameters to my stored procedures?

asked Nov 13 '09 at 10:10 AM in Default

Anthony Osborn ♦♦
171 ● 6 ● 8 ● 10

(comments are locked)

1 answer:

0

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
as
return

answered Nov 13 '09 at 10:27 AM

dave ballantyne
918 ● 1 ● 1 ● 4

(comments are locked)

Your answer

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Follow @Ask_SSC

Follow Ask SSC on Facebook

Find Ask SSC on Google+

Find us on LinkedIn

Topics:

stored-procedures x340
parameters x66

asked: Nov 13 '09 at 10:10 AM

Seen: 1012 times

Last Updated: Apr 21 '10 at 05:38 PM

Related Questions

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.