Allow Parameterized SQL to accept parameter arrays - by mpswaim

Status : 

  Fixed<br /><br />
		This item has been fixed in the current or upcoming version of this product.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 150938 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 6/28/2006 10:12:42 PM
Access Restriction Public


SQL Server currently doesn't allow one to pass in arrays as parameters. If it did, parameterized In statements would become useful, and one would be able to lower the network traffic for common operations. (Oracle supports this, and you get a decent return for little effort when doing a bunch of inserts or updates.)
Sign in to post a comment.
Posted by Microsoft on 10/16/2007 at 1:18 AM

We have added table-valued parameters in SQL Server 'Katmai'. This should allow you to achieve what you are requesting for. This is currently available in Katmai CTPs. Please let us know if you have any additional feedback.

Vineet Rao
Microsoft SQL Server
Posted by Microsoft on 7/5/2006 at 6:36 PM
Thanks for the feedback. We are considering alternatives for how to enable this in a future release of SQL Server.

- Christian Kleinerman