T-SQL input parameter as stringArray()

Question

I am writing update query "Update tbl_List Set ListName = 'Hello' where ListId IN (stringArray()).

I have added 5 string values in stringArray() and how to pass it as input parameter to SQL ? How to execute query with Array values?

ListId is string?

Ilyes
– Ilyes

2017-05-31 11:29:01 +00:00
Commented May 31, 2017 at 11:29 — Ilyes
– Ilyes, Commented May 31, 2017 at 11:29
Yes, it's String

VHK
– VHK

2017-05-31 12:21:55 +00:00
Commented May 31, 2017 at 12:21 — VHK
– VHK, Commented May 31, 2017 at 12:21
See table valued parameters.

Bogdan Sahlean
– Bogdan Sahlean

2017-05-31 13:06:03 +00:00
Commented May 31, 2017 at 13:06 — Bogdan Sahlean
– Bogdan Sahlean, Commented May 31, 2017 at 13:06

Ilyes · Accepted Answer · 2017-05-31 11:46:49Z

1

You can create your query as :

Update tbl_List Set ListName = 'Hello' where ListId IN ('value1' , 'value2' ,'valueN');

Or using a table :

Declare @Val Table (IDs Nvarchar(50) );

Insert into @val values ('value1'),('value2'),('valueN');

Update tbl_List Set ListName = 'Hello' where ListId IN (Select IDs From @Val);

You can loop in your StringArray to pass values , and you can use only one parametre and excute your query as much as the length of your Array.

Also you can use temp tables for that job.

edited May 31, 2017 at 11:46

answered May 31, 2017 at 11:38

Ilyes

15k5 gold badges31 silver badges61 bronze badges

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

Collectives™ on Stack Overflow

T-SQL input parameter as stringArray()

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related