Home Forums SQL Server 2008 T-SQL (SS2K8) Optional Parameters in Stored Procedures RE: Optional Parameters in Stored Procedures

  • July 16, 2012 at 3:38 pm

    #1513347

    You can use a lookup table to store default/control values.

    Or, less overhead but more obscure, you can store the default/control values in specific byte positions of CONTEXT_INFO.

    SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.