Best way to delete duplicate rows

mikkoerva · June 9, 2020, 1:13pm

What’s best way to delete duplicate rows from DB when using DataAbstract?

EvgenyK · June 9, 2020, 1:19pm

Hi,

what platform (Delphi or .NET) you are using?
what DB (MSSQL, MySQL, etc) you are using?

mikkoerva · June 9, 2020, 1:41pm

Delphi and SQL Express.

EvgenyK · June 9, 2020, 2:22pm

Hi,

the best way - do it via command/stored procedure on MSSQL side w/o usage of delphi code
another way - you can download all records to delphi project, manually detect duplicates, mark them and delete consistently

mikkoerva · June 9, 2020, 6:23pm

Thanks for answer. Made StoredProc to MSSQL and used Devarts SDAC.