title: Select columns into an array in SQL Server Stored Procedure
body: <p>My table consists of multiple phone number columns and I want to select multiple columns (say phone numbers) into an array for my store procedure. I am trying to use <code>SELECT</code> but it returns only one value as shown in the sample code</p>
  
  <pre><code>DECLARE @phone VARCHAR(15)
      SELECT @phone = phone1 FROM AddressTable
  PRINT @phone
  </code></pre>
  
  <p>Now I want get the values of more than one column value into one variable. I know for this purpose we normally use arrays. But I am not sure how to use. Any Help...!!!</p>