how to store array in micro sql server database?

[lucoin]

I am using .net asp with c# and sql server 2005 express edition to develop an enrollment system, for the subjects, they may have more than one pre-requisites. when I stored the pre-requisites, how should I design the data table column like "Sbuject_Pr e", what the data type it should be? when I retrieve this column, how should I do? Thank you!

[UEH1]

> how to store array in micro sql server database?

I'm sorry, but this array of what elements?...

anyway, you can use the following scheme:

[ id ] [ next_id ] [ data ]
next_id --> [ id ] [ next_id ] [ data ]
and so on until next_id <> 0.

something like that