Default Parameters

• BSavoie

  SSCertifiable

  Points: 6309

  More actions

  January 13, 2012 at 2:46 pm

  #266436

  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!

  .

• Elliott Whitlow

  SSC Guru

  Points: 102402

  More actions

  January 13, 2012 at 3:12 pm

  #1433565

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

  CEWII

• BSavoie

  SSCertifiable

  Points: 6309

  More actions

  January 13, 2012 at 3:19 pm

  #1433570

  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.

  .