Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Default Parameters Expand / Collapse
Author
Message
Posted Friday, January 13, 2012 2:46 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, December 12, 2014 1:28 PM
Points: 309, Visits: 730
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!


.
Post #1235981
Posted Friday, January 13, 2012 3:12 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, October 9, 2014 1:02 PM
Points: 6,032, Visits: 5,284
Yes, 2000 supports default parameters. I'm almost 100% sure that 6.0, 6.5, and 7 do as well..

CEWII
Post #1236004
Posted Friday, January 13, 2012 3:19 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, December 12, 2014 1:28 PM
Points: 309, Visits: 730
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.

.
Post #1236009
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse