T-SQL global variables

[MikeDNova]

Is it possible to use global variables in T-SQL? and how? if not, what's the common way to get around this problem?

Thanks in advance!
Mike

 

[TJRTech]

Global in what regards? Global across Stored Procs? Global across connections?

I would think that where you have a need for such globals, that you store them as meta-data in your database. Just create a new table, called "GLOBAL_VARIABLES" or somesuch, give them a name and a data type, value, etc, and nice SPs for getting, setting, locking...etc.

Regards,
TR

 

[MikeDNova]

Yeah something like that might work. But what I'm trying to do is call a function, set the global variable, then call then function again and remember the global. Maybe there's no easy way to do this in T-SQL.

 

[TJRTech]

Variables within functions that retain their value across invocation are known as "static" variables.

T-SQL doesn't have anything like that, at least not that I am aware of.

TR

 

[martyc71]

Create a Global Variable Table and insert the values for your variable there.

 

[TJRTech]

Great idea mcarrillo...where did I hear that before?

;-)

tr

 

[martyc71]

TJRTech Just agreeing with your creative solution.

mcarrill aka martyc71