Home Dashboard Directory Help
Search

Allow Parameterized SQL to accept parameter arrays by mpswaim


Status: 

Closed
 as Fixed Help for as Fixed


3
0
Sign in
to vote
Type: Suggestion
ID: 150938
Opened: 6/28/2006 10:12:42 PM
Access Restriction: Public
0
Workaround(s)
view

Description

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.)
Details
Sign in to post a comment.
Posted by Microsoft on 10/16/2007 at 1:18 AM
Hello,

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.

Thanks,
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
Sign in to post a workaround.