SQL Server Performance Forum – Threads Archive

Import/Update a Column?

I’ve been using ASSYST 6.0 as a front end to SQL 2000.
They have an import App which i used to import the data.
I was then given an extra column of information to import into the corresponding
column in the table. this is where the problem starts. the import app says no records have been updated.
Is there a way of importing a column into a view within SQL itself? or will the main table update correctly if i do an import of the whole table. without losing the other data(i.e.) the data which is to be ‘updated’ is only a small percentage of the amount of rows in the table. Any help would be very welcome Damon.

---

I think u can use Update command for this,
Can u please specify the few data rows so that we can get an idea of your data

---

]]>