May 31, 2016 at 6:42 am
Hi All,
I am interested in having a list of sql server 2012 global variables (the ones with name @@<var>), I am checking the online manuals and I don't find it, maybe I am missing just the part where it is located. Does anyone know if there is an official list ?.
Thanks in advance.
May 31, 2016 at 6:53 am
This is probably what you're looking for:
https://msdn.microsoft.com/en-us/library/ms173823.aspx
-- Gianluca Sartori
May 31, 2016 at 6:54 am
Using Books On Line simply enter @@ in the "Look for:" line. You are just missing it. No big thing..
May 31, 2016 at 7:06 am
Regarding the link mentioned above (https://msdn.microsoft.com/en-us/library/ms173823.aspx) ... this seems not to be the complete list at all, what about other typical like @@rowcount or @@trancount ?, they are not there. The curious thing is that they appear with a name I didn't expect (Configuration Functions)
Regarding the search ... I also thought this was not a big deal until I try to find it, I have tried for instance in https://technet.microsoft.com/en-US/ where I usually find almost everthing and no luck (no way with @@, I have tried global vars. system vars ... and no luck). Try yourself if you want ;-).
Thanks for the quick answers.
May 31, 2016 at 7:14 am
I don't think there's a single list of just the @@ values. They're used for different things in different ways and the usage seems to determine their placement within the books online, not simply the fact that they're all global variables. Searches are probably the best approach.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply