Passing Multidimensional array to sql server 7.0 stored procedure?

[ramki431]

Does it possible to pass a multi dimensional array to a
stored procedure in sql server 7.0?

Please pass on some examples if any of you have.

 

[tlbroadbent]

There is no array variable, single or multi-dimensional in SQL Server. Download scripts from the following links to see ways to handle delimited strings as arrays.

http://www.swynk.com/downloads/MultiValueParam.sql

http://www.swynk.com/downloads/usp_UpdateTablewithArray.txt

http://www.swynk.com/downloads/splitquery.sql

Terry L. Broadbent
Programming and Computing Resources

http://tlbroadbent.home.attbi.com/prog.htm

 

[cmmrfrds]

If you are fimilar with ADO, you can use ADO to create a temporary table which you could load with your array. In the stored procedure you could read the values out of the temporary table and then drop the table when you are finished.