I have the same row records in the database, how to update only one of them.

huntereijij

I want to update through the SqlDataAdapter, do not delete and insert first, modify the record of a certain row directly in the returned table, and then update the data source, what should I do? After trying for a long time without success

7889638

At least the key values ​​are not repeatable

疾风劲草

select * from tablename where = condition // remove the same records
Locate a record update:
update tablename
set deptno = 20
where rownum = record number;

Not tested.

zhouji700

If the table has no key values, then it should be unlikely.
Upstairs is ORACLE, SQLSERVER does not have ROWNUM

zhengminglin

You must have a primary key.The database should not allow exactly the same records.It is not possible to use identity as the primary key.

liuhua56

It's OK to distinguish by ID.

redfish119

top 1 where ........

huntereijij

It's just annoying without a master

Very special

Hey----------------