Does that mean that one can not add a global variable, or that it is done differently than a declaration. If the latter, how is it done??
>Normally the @@ or double @ is used to denote a global variable, but as these can not be declared it's use in your case is redundant.
>
>Mace
>
>>I have come across some SQL code in a legacy database here that uses variables declared as
>>
>>DECLARE @@ThisVariable Char(25), ... etc.
>>
>>I have not seen, nor do I find, any reference to a variable so declared in the BOL. I need to update this proceedure, and do not want to cause any problems due to a lack of understanding. Any help is appriciated, as always. :)
Thank You
Rollin Burr
Politicians and diapers have one thing in common. They should both be changed regularly, and for the same reason.