Solving methods on string merging

szs800528 · Post time: 2020-2-2 14:40:01

Concatenates the values in each record of a string field into a string

terryyang · Post time: 2020-3-20 22:30:02

declare @str varchar (8000)
select @ str = @ str + Column from tablename

terryyang · Post time: 2020-3-21 06:45:01

declare @str varchar (8000)
set @ str = ''-sometimes without assignment
select @ str = @ str + Column from tablename

fanfan1980 · Post time: 2020-3-21 16:00:01

declare @str varchar (8000)
set @ str = ''
select @ str = @ str + colName + '' from tbName

select @str

		Remember me	Forgot password?
Password			Register