Default Parameters

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Older Versions of SQL (v6.5, v6.0, v4.2) » Older Versions of SQL (v6.5, v6.0, v4.2) » Default Parameters

Default Parameters

Rate Topic

Display Mode

Topic Options

Author

Message

BSavoie

Posted Friday, January 13, 2012 2:46 PM

Old Hand

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 2:38 PM
Points: 309, Visits: 719

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

Elliott Whitlow

Posted Friday, January 13, 2012 3:12 PM

SSCertifiable

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 12:02 PM
Points: 5,854, Visits: 4,873

Yes, 2000 supports default parameters. I'm almost 100% sure that 6.0, 6.5, and 7 do as well..

CEWII

Post #1236004

BSavoie

Posted Friday, January 13, 2012 3:19 PM

Old Hand

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 2:38 PM
Points: 309, Visits: 719

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 »

Permissions