Q: How do I retrieve values from a table and store the results in a string?

Q: How do I retrieve values from a table and store the results in a string?

A: The following code provides a simple yet effective method for retrieving values from a table and storing the results in a string, 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 @string

You need to initialize your string to a non-NULL value, or the string will end up as NULL, which is the default behavior of NULLs and string concatenation.

—Bill McEvoy

Hide comments

Comments

  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
Publish