store result of select query into array variable

Question

I want to store the result of this sql query in variable @a. The result contains 17 rows. How to edit this code in order to store the rows in @a?

declare @a uniqueidentifier
select EnrollmentID into @a  from Enrollment

Giorgos Betsos · Accepted Answer · 2016-03-15 11:05:26Z

21

You cannot store 17 values inside a scalar variable. You can use a table variable instead.

This is how you can declare it:

DECLARE @a TABLE (id uniqueidentifier)

and how you can populate it with values from Enrollment table:

INSERT INTO @a 
SELECT EnrollmentID FROM Enrollment

answered Mar 15, 2016 at 11:05

Giorgos Betsos

72.3k10 gold badges69 silver badges103 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

S.Karras · Accepted Answer · 2016-03-15 11:07:02Z

4

You should declare @a as a Table Variable with one column of type unique identifier as follows:

DECLARE @a TABLE (uniqueId uniqueidentifier); 

INSERT INTO @a
SELECT EnrollmentID 
FROM Enrollment;

answered Mar 15, 2016 at 11:07

S.Karras

1,49315 silver badges19 bronze badges

how your answer is different from the accepted answer ?