Select columns into an array in SQL Server Stored Procedure

Question

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 SELECT but it returns only one value as shown in the sample code

DECLARE @phone VARCHAR(15)
    SELECT @phone = phone1 FROM AddressTable
PRINT @phone

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...!!!

Are you just trying to concatenate multiple columns into a single variable? SELECT @phone = phone1 + ', ' + phone2 ... — sgeddes
– sgeddes, Commented Jun 5, 2013 at 1:06
@Vikram . . . What are you actually trying to accomplish? The table format might be quite sufficient to solve your problem. — Gordon Linoff
– Gordon Linoff, Commented Jun 5, 2013 at 1:28
I am trying to verify the phone number format for 5 columns. I am using tsqlt. I used table format and I found its helpful. But I need to compare those results with a unique number — Vikram
– Vikram, Commented Jun 5, 2013 at 1:44
@Vikram . . . Why do you need all the numbers at once for verification? Just validate one phone number at a time. — Gordon Linoff
– Gordon Linoff, Commented Jun 5, 2013 at 1:47
I need to test with different permutations so testing all the phone numbers columns for each test with unique phone number. which will finish off 8 tests for 5 fields. — Vikram
– Vikram, Commented Jun 5, 2013 at 1:49

Community · Accepted Answer · 2017-05-23 12:28:57Z

1

SQL doesn't support arrays. You can use something like a table variable or a comma delimited string

SELECT INTO a table variable in T-SQL

edited May 23, 2017 at 12:28

CommunityBot

11 silver badge

answered Jun 5, 2013 at 1:05

TGH

39.4k13 gold badges106 silver badges140 bronze badges

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

2 Comments

Vikram Over a year ago

You mean append all the phone numbers into a string?

TGH Over a year ago

I would go with the table variable, but you could go the delimited string route as well... Or xml or some other "multi" value format

Collectives™ on Stack Overflow

Select columns into an array in SQL Server Stored Procedure

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related