Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Matlab Toolbox / Update

Author  Topic 

sqlsql_4747
Starting Member

2 Posts

Posted - 2010-02-22 : 20:29:58
Hi Guys,

i'm using Matlab Database toolbox to alter data in my SQL Database.
My problem is as follows:

i need to implement an array, or matrix into SQL column.
the columns has 40,000 (!) rows,
my Matlab-array has 40,000 values

basically it is just replacing my entire column (lets call it CONNECTIONS), by the new data coming from Matlab (lets call it MATDATA) [in a xls spreadsheet i could copy paste the items, they are in the same order and have the same amount of data points]

approaching this with update is weird, because of the where clause,
i don't have information on the where clause.


please help!

thank you!!


   

- Advertisement -