title: How can I pass an array to IN operator in select query in SQL Server as a parameter?
body: <p>I have this SQL Server query:</p>
  
  <pre><code>SELECT * 
  FROM Customers
  WHERE CustomerID IN ('4','11',"16");
  </code></pre>
  
  <p>Instead of passing a parameter <code>('4','11',"16")</code> like this, I want to create an array variable like this [4,11,16]. and I want this to send to the above query. How can I do this? I tried the below query, but it's not working.</p>
  
  <p>Can anybody help me with this?</p>
  
  <pre><code>SELECT * 
  FROM Customers
  WHERE CustomerID IN (['4','11',"16"]);
  </code></pre>