Question: How to pass an array into an SQL statement and submit it to a database ?

Answer: 
If you're using SQL Server you can pass XML parameters into a stored procedure and then do a select on the nodes within the SP itself.

<http://weblogs.asp.net/jgalloway/archive/2007/02/16/passing-lists-to-sql-server-2005-with-xml-parameters.aspx>
In PostgreSQL this is quite easy:

```

INSERT INTO some_table (some_column, array_column)
VALUES
(42, ARRAY[4,2]);

```