Passing an array into a Stored Procedure
Home > IT Answers > Development > Passing an array into a Stored Procedure
Khperi
5 pts.
0
Q:
Passing an array into a Stored Procedure
Arrays, SQL Server stored procedures, Java, Stored Procedures
is there a possibility of passing an array into a Stored procedure
i am using java and sqlserver 2000
ASKED: Jan 30 2009  7:40 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Msi77
800 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
No, SQL Server doesn't support array's an input parameters. SQL Server 2008 allows you to use a table variable as an input parameter.

Your best option will be to create an XML Document and pass the XML document to the stored procedure, then parse the XML document using OPENXML within the stored procedure to get it back into a relational dataset.
------------------
Look here:
arrays-in-sql-2000
Last Answered: Feb 2 2009  5:51 PM GMT by Msi77   800 pts.
Latest Contributors: Mrdenny   46795 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0