store result of select query into array variable
<p>I want to store the result of this sql query in variable <code>@a</code>. The result contains 17 rows. How to edit this code in order to store the rows in <code>@a</code>?</p>
<pre><code>declare @a uniqueidentifier
select EnrollmentID into @a  from Enrollment
</code></pre>