"Nils Wolf" <nisse@gmx.at> wrote in message
news:e9bT6j4yFHA.1032@TK2MSFTNGP12.phx.gbl...
> Hi,
>
> I need to store a 2D Array in a Table.
> What is the easiest way to to this. the array would only contain integer
> values..
>
> anyone a better idea than "implode" the Array in a string and "explode" it
> again in the program code?
>

"Nils Wolf" <nisse@gmx.at> wrote in message
news:uyqrCv4yFHA.3860@TK2MSFTNGP09.phx.gbl...
> the Array is not so small.
>
> it would be at least (100 x 100) up to (400 x 300)
>
> the point is, that i need one array per row in a table with about 1000
> rows...
>
> Nils
>
>
> "David Browne" <davidbaxterbrowne no potted meat@hotmail.com> schrieb im
> Newsbeitrag news:uqw%23Wq4yFHA.2424@TK2MSFTNGP12.phx.gbl...
>>
>> "Nils Wolf" <nisse@gmx.at> wrote in message
>> news:e9bT6j4yFHA.1032@TK2MSFTNGP12.phx.gbl...
>>> Hi,
>>>
>>> I need to store a 2D Array in a Table.
>>> What is the easiest way to to this. the array would only contain integer
>>> values..
>>>
>>> anyone a better idea than "implode" the Array in a string and "explode"
>>> it again in the program code?
>>>
>>
>> Well, storing it in a binary IMAGE column, or VARBINARY if it's small is
>> a whole lot better than using a string. Most programming environments
>> know how to convert integer arrays back and forth to byte arrays, and SQL
>> Server knows how to store and retrieve byte arrays.
>>
>> But consider whether it's really best to hide the structure of your data
>> from SQL Server. Sometimes there's really no alternative, but if you can
>> find a way to model your data with tables and rows, it might be easier to
>> store, retrieve and manipulate, and if your arrays are sparse it may even
>> be more efficient.
>>
>> David
>>
>

"Nils Wolf" <nisse@gmx.at> wrote in message
news:e9bT6j4yFHA.1032@TK2MSFTNGP12.phx.gbl...
> Hi,
>
> I need to store a 2D Array in a Table.
> What is the easiest way to to this. the array would only contain integer
> values..
>
> anyone a better idea than "implode" the Array in a string and "explode" it
> again in the program code?
>
> Nils

>
> "Nils Wolf" <nisse@gmx.at> wrote in message
> news:e9bT6j4yFHA.1032@TK2MSFTNGP12.phx.gbl...
>> Hi,
>>
>> I need to store a 2D Array in a Table.
>> What is the easiest way to to this. the array would only contain integer
>> values..
>>
>> anyone a better idea than "implode" the Array in a string and "explode"
>> it again in the program code?
>>
>
> Well, storing it in a binary IMAGE column, or VARBINARY if it's small is a
> whole lot better than using a string. Most programming environments know
> how to convert integer arrays back and forth to byte arrays, and SQL
> Server knows how to store and retrieve byte arrays.
>
> But consider whether it's really best to hide the structure of your data
> from SQL Server. Sometimes there's really no alternative, but if you can
> find a way to model your data with tables and rows, it might be easier to
> store, retrieve and manipulate, and if your arrays are sparse it may even
> be more efficient.
>
> David
>