What does “+=” mean in T-SQL

• guerillaunit

  SSCarpal Tunnel

  Points: 4249

  More actions

  August 16, 2012 at 10:01 am

  #279841

  What does the following variable assignment mean in T-SQL?

  SET @myvariable += 'test'

• MysteryJimbo

  SSC-Insane

  Points: 24203

  More actions

  August 16, 2012 at 10:10 am

  #1526704

  guerillaunit (8/16/2012)

  ---

  What does the following variable assignment mean in T-SQL?

  SET @myvariable += 'test'

  Append to the existing value. Same as

  SET @myvariable = @myvariable + 'test'

• BrainDonor

  SSCoach

  Points: 19254

  More actions

  August 16, 2012 at 10:21 am

  #1526712

  Also known as a Compound Operator, and there are several:

  http://msdn.microsoft.com/en-us/library/cc645922.aspx

  Steve Hall
  Linkedin
  Blog Site