January 13, 2012 at 2:46 pm
I have to add a couple new parameters to a stored proc. running on an old sql 2000 server. Obviously I don't want to break existing code so I want to use default values. Does sql 2000 support default values for stored procedure parameters? It seems like defaults came along after sql 2000.
Thanks!
.
January 13, 2012 at 3:12 pm
Yes, 2000 supports default parameters. I'm almost 100% sure that 6.0, 6.5, and 7 do as well..
CEWII
January 13, 2012 at 3:19 pm
Great. Thanks for the quick response. I can't actually get to the box to try it. I'm sure you're right. Maybe I'm thinking of variable initializers.
.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy