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 |
|
SQLIsTheDevil
Posting Yak Master
177 Posts |
 Posted - 2007-10-23 : 10:36:45
|
| I was doing some research and I noticed there's a reserved word called global, but I couldn't find any information on its purpose or things of that nature. What is the purpose of this reserved word and how do I use it? If anyone can point me in the right direction, I'd sincerely appreciate it. Thank you. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
SQLIsTheDevil
Posting Yak Master
177 Posts |
Posted - 2007-10-23 : 10:50:01
|
| I think you misunderstand my question. I realize it's a reserved word. I know what reserved words are. I want to know what is the purpose of "global"? What is its function? |
 |
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-10-23 : 11:02:53
|
From books online, extended transact sql arguments:GLOBALSpecifies that the scope of the cursor is global to the connection. The cursor name can be referenced in any stored procedure or batch executed by the connection. The cursor is only implicitly deallocated at disconnect.
Future guru in the making. |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-10-23 : 11:04:18
|
| Reserved words don't have to have a function. Could be that they are reserved for future use or just part of a standard.Even if they are reserved it doesn't mean you can't use them - might cause problems in the future though.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
SQLIsTheDevil
Posting Yak Master
177 Posts |
Posted - 2007-10-23 : 11:06:33
|
| Thank you. |
|
|
|
|
|
|
what is the "global" reserved word in sql server?