Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What's the difference?
Message
From
04/09/1999 14:43:27
Larry Long
ProgRes (Programming Resources)
Georgia, United States
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
What's the difference?
Miscellaneous
Thread ID:
00261530
Message ID:
00261530
Views:
56
In a stored proc, what would be the difference between the following statements?

SELECT cretvalue="string value"

and

SELECT @cretvalue="string value"

and

SELECT cretvalue as @cretvalue

The statements show up numerous times in stored procs that I am trying to debug. I know that '@cretvalue' refers to a local variable, but 'cretvalue' is never initialized anywhere in any of the sp's that I can see.
L.A.Long
ProgRes
lalong1@charter.net
Next
Reply
Map
View

Click here to load this message in the networking platform