sql - write new values to variable but keeping the old value -

sql - write new values to variable but keeping the old value -

example:

declare @string varchar(100) set @string = 'test string' -- add together string set @string = 'test string 2' select @string --return 'test string''test string 2'

how this?

you can append string this.

declare @string varchar(100) set @string = 'test string ' -- add together string --tsql 2005 set @string = @string + 'test string 2' --tsql 2008+ --set @string += 'test string 2' select @string

sql sql-server tsql