How to pass an array in stored procedure?

[smitha_aa]

Hi,

I have web page which has an array.I want that array to be passed in to stored procedure?Can anybody tell me how to do this?

wen the stored procedure is executed i want the following output.

a[0]=a,a[1]=b,a[2]=c etc...

[radhakrishna.p]

hai smitha_aa,

i am not aware of c# or .net but the following links may helps you

http://www.primaryobjects.com/cms/article79.aspx

http://social.msdn.microsoft.com/Forums/en/sqlsmoanddmo/thread/daf5361f-5633-48a8-bd94-7a39a95f72b5

http://stackoverflow.com/questions/11102358/how-to-pass-an-array-into-a-sql-server-stored-procedure

happy coding

[smitha_aa]

Hi,

I'm still not able to pass array in stored procedure(MY SQL).Can please anyone help me..
Thanks,

[ChrisHunter]

Have you tried looping through the array and executing the procedure for each index in the array?

[Ketsuekiame]

Nevermind, misread MY SQL as MS SQL

[ChrisHunter]

I tried to do something similar for an SQL Server 2005 project i'm working on but realised creating types (which would solve my problem) wasn't introduced untill the 2008 version.

Take a look at these links:

Link 1

Link 2