User Defined Global l Varible in SQL 2000 Server

• Prem C Kannaujiya

  Newbie

  Points: 7

  More actions

  December 21, 2004 at 6:04 am

  #102318

  Hi,

  It is possible in SQL 2000 Server to Define Global variable which i can

  use in any where in sql or any procedure.

   

  With regs

  prem

   

   

• AJ Ahrens

  SSC-Insane

  Points: 20676

  More actions

  December 21, 2004 at 8:25 am

  #534629

  Yes,

  1. Create a table and store the global variable in it
  2. Create a UDF and return the global variable

  
  
  Good Hunting!

  AJ Ahrens
  
  
  webmaster@kritter.net