difference between the local variable and globla variable

• dastagiri16

  Hall of Fame

  Points: 3544

  More actions

  October 3, 2012 at 2:07 pm

  #393309

  hi team,

  Could you plesae explian with any example how to use/declare local and globle variables in t-sql block..

  Thanks,

  Dastagiri

• GSquared

  SSC Guru

  Points: 260824

  More actions

  October 3, 2012 at 2:25 pm

  #1545213

  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

• OTF

  SSCertifiable

  Points: 6104

  More actions

  October 4, 2012 at 4:06 am

  #1545433

  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.