How can I send array to stored procedure? I want send it from JS to stored procedure. And what is the best data format for this task?
SQL 2008 supports table valued parameters - so you can pass a table of data as a parameter to a sproc. The common ways prior to this, were as mentioned already - via a CSV or XML parameter.