Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
@@Variable??
Message
From
22/11/2005 17:12:59
 
 
To
22/11/2005 08:25:22
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Miscellaneous
Thread ID:
01071134
Message ID:
01071338
Views:
23
>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. :)


This declare the @@ThisVariable local variable.
DECLARE @@ThisVariable Char(25)
SELECT @ThisVariable -- error
This declare the @@@@@@@@@@@@@@@@@@@@@@@@@@@ variable
DECLARE @@@@@@@@@@@@@@@@@@@@@@@@@@@ Char(25)
SELECT @@@@@@@@@@@@@@@@@@@@@@@@@@@
Previous
Reply
Map
View

Click here to load this message in the networking platform