Default Parameters

  • BSavoie

    SSCertifiable

    Points: 6309

    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: 102296

    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

    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 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply