Have you ever wanted to retrieve a list of values from a table, storing the results in a string?
Here is simple yet effective method without having to rely on cursors, while loops, or other complex structures.
declare @string varchar(8000)
select @string = ''
select @string = @string + MyColumn
from MyTable
print @stringIt is important to initialize your string to a non-NULL value, otherwise your string will end up as NULL, which is the default behavior of NULLs and string contcatenation.
Give it a try, it works like a charm. 😎
![image 2 - [ERROR] Unknown/unsupported storage engine: InnoDB](https://i0.wp.com/pcx3.com/wp-content/uploads/2023/01/image-2.png?resize=344%2C194&ssl=1 "[ERROR] Unknown/unsupported storage engine: InnoDB")
