we are using sql server 2000. we have two rows with same data. we want to delete only one row. how to do it?
in sql server 2005 with the help of rowid we can do that.we are not able to delete the duplicate row in sql server 2000.
Printable View
we are using sql server 2000. we have two rows with same data. we want to delete only one row. how to do it?
in sql server 2005 with the help of rowid we can do that.we are not able to delete the duplicate row in sql server 2000.
One way can try is set rowcount = 1 then run delete statement.