global constant

• ouertani neked

  SSC-Addicted

  Points: 406

  More actions

  June 7, 2004 at 11:10 am

  #108454

  

  Hi every Body,

  Question: can we declare a global constant then use it in

  different SPs (how package?!)

  Thanks

• rockmoose

  SSCarpal Tunnel

  Points: 4601

  More actions

  June 7, 2004 at 11:29 am

  #509285

  Hi,

  Put the global constant(s) in a table.

  Then write a scalar function to access the global constant(s),

  Or just select from this table to retrieve the constant in the table.

  If you need global constants of different datatypes, consider making use of the sql_variant datatype.

  /rockmoose

  
  You must unlearn what You have learnt