How to input an array to IN clause in SQL? [closed]

Question

Closed. This question needs details or clarity. It is not currently accepting answers.

Want to improve this question? As written, this question is lacking some of the information it needs to be answered. If the author adds details in comments, consider editing them into the question. Once there's sufficient detail to answer, vote to reopen the question.

Closed 7 years ago.

Improve this question

string[] questions= new[] { "2","5","1","11","3","1"};

    select description,count(description) 
      from descriptions 
inner join questions 
        on descriptions.qid=questions.id 
     where descriptions.question=N'hardtest' 
       and qid in (?) 
  group by description

I want to use an array in this code as an input to IN clause. How can I do that?

qid in ('" + list + "')

Possible duplicate of Passing a SQL parameter to an IN() clause using typed datasets in .NET — Sunil
– Sunil, Commented Jan 8, 2018 at 7:01

wangguanguo · Accepted Answer · 2018-01-08 07:35:22Z

2

string[] questions = new[] { "2", "5", "1", "11", "3", "1" };

string qids = string.Empty;
questions.All((x) => { qids += "','" + x; return true; });
qids = qids.Substring(2);

string sql = @"
select description, count(description)
  from descriptions
inner join questions
    on descriptions.qid = questions.id
where descriptions.question = N'hardtest'
   and qid in ("+qids+@"')
group by description";

answered Jan 8, 2018 at 7:35

wangguanguo

1814 bronze badges

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

3 Comments

Ali Mousavi Over a year ago

i'll wait until another optimized code ,if...

Sunil Over a year ago

This is vulnerable to SQL Injection attack.

wangguanguo Over a year ago

since the qid is int,the simpliest way is :questions.All((x) => { qids += Int32.TryParse(x,out id)?"','" + x:""; return true; });

Collectives™ on Stack Overflow

How to input an array to IN clause in SQL? [closed]

1 Answer 1

3 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Linked

Related