October 3, 2012 at 2:07 pm
hi team,
Could you plesae explian with any example how to use/declare local and globle variables in t-sql block..
Thanks,
Dastagiri
October 3, 2012 at 2:25 pm
No such thing as global variables in T-SQL. They used to call some of the system functions "global variables", but they never really were that, and Microsoft stopped calling them that years ago.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
October 4, 2012 at 4:06 am
dastagiri16 (10/3/2012)
hi team,Could you plesae explian with any example how to use/declare local and globle variables in t-sql block..
Thanks,
Dastagiri
The concept of "global variables" doesn't really exist in T-Sql. You could probably "mimic" them with the use
of ##Temporary Tables but it might be best if you specify what you are trying to achieve as you will almost certainly get pointed in a better direction here.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy