Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Big_tim
Starting Member
22 Posts |
 Posted - 2010-08-09 : 11:31:25
|
| Ok, so this is probably a really obvious question, but could someone post a link to a good explanation of the double @@ in SQL? (It's not an easy thing to search for since search engines won't search for it! Apologies if this is covered somewhere else that I can't find...) |
|
|
slimt_slimt
Aged Yak Warrior
746 Posts |
Posted - 2010-08-09 : 11:38:56
|
| you fill find functions here:[url]http://msdn.microsoft.com/en-us/library/aa258899(SQL.80).aspx[/url] |
 |
|
|
slimt_slimt
Aged Yak Warrior
746 Posts |
Posted - 2010-08-09 : 11:41:12
|
| http://msdn.microsoft.com/en-us/library/aa258899(SQL.80).aspx |
|
|
|
slimt_slimt
Aged Yak Warrior
746 Posts |
Posted - 2010-08-09 : 11:41:34
|
| these brackets are making me nuts :S |
|
|
|
Big_tim
Starting Member
22 Posts |
Posted - 2010-08-09 : 11:49:09
|
| Ok, ta for that, but going to complete basics, what does @@ actually mean? Like @ is a variable - what does putting the extra @ mean? |
|
|
|
slimt_slimt
Aged Yak Warrior
746 Posts |
Posted - 2010-08-09 : 11:55:08
|
| it denotes reserved words and built in functions for several purposes.why an extra @ - that i don't know |
|
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2010-08-09 : 12:26:27
|
| It doesn't have anything to do with reserved words. Rather @ is for a local variable and @@ is for a global functions (I wonder if there were global variables at one time??).Just a guess, but probably some convention that the original Sybase developers came up with.. |
|
|
|
|
|
|
@@