Post reply

Database Global Variable

  • June 5, 2003 at 8:19 am

    #159163

    Hi there,

    Dunno if this is what you would call it, but i need to create a database wide variable. Its a script which uses a remote server name and i'm developing it (and lots of other scripts) on a development server using a remote development server. When i put it live, the hardcoded name will have to be changed everywhere. Is it possible to set it up for the whole database (hope that made sense...)

    Thanks

    Meg

  • June 5, 2003 at 8:35 am

    #459961

    Why not store it in a table?

  • June 12, 2003 at 5:42 am

    #461033

    I agree with jpipes, store the value(s) in a table, this is the way Microsoft (and Sybase) store lookup values.

    See master.dbo.spt_values as an example. (I have read articles referring to this table as "The Mother of All Lookup Tables"!!)

Viewing 3 posts - 1 through 2 (of 2 total)

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