Creating global variable?

[sagn]

Hi,

How can I create a global variable?

I have several stored procedures that I would like
to share a few global (and will be static) variables?
I;ve tried declaring them using @@ but they are not
recognized once
the SP in which they where declared is exited.


Thanks

ds

 

[fluteplr]

No such animal in sql server. You might consider setting up a table (I usually call mine config or options) and setting those values in the table. You can then retrieve them using

select @myvariable = config.myvariable from config

 

[sagn]

Hmmmm. Drats!

OK That's easy enough. I suppose I'll do that.

Thanks

ds

 

[foxdev]

Expanding on fluteplr's suggestion, you could make a global temp table; simply preface the name with '##'. This table would be visible across connections, but will not persist forever. Robert Bradley

http://www.agrainofhope.org

http://www.lowcostprints.com

http://www.foxdev.com