How can I send a table to a stored procedure? What is the best data format if I send it from JS?

advertisements

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.

MSDN Reference