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.
| Author |
Topic |
|
khalik
Constraint Violating Yak Guru
443 Posts |
 Posted - 2002-04-03 : 05:58:55
|
| hi when we have a dulpicate record.. oracle has a facility of dlete the one record... rowidin sql do we have a equal....i have sql 2000thanks======================================Ask to your self before u ask someone |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-04-03 : 07:33:48
|
| you can add a identity field , delete the duplicate records and drop the field.Check Graz article on deleting duplicate records http://www.sqlteam.com/item.asp?ItemID=3331-------------------------------------------------------------- |
 |
|
|
khalik
Constraint Violating Yak Guru
443 Posts |
Posted - 2002-04-04 : 01:11:19
|
| dont we have a other way of doing it...======================================Ask to your self before u ask someone |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-04-04 : 01:12:11
|
| Use Oracle.What's wrong with the method described in the article? You want to delete duplicates, that what it does.Edited by - robvolk on 04/04/2002 01:13:43 |
|
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-04-04 : 01:16:30
|
or go to EM and delete reach duplicate row , yeah it will take some extra effort and time. but then you want another way rite  -------------------------------------------------------------- |
|
|
|
khalik
Constraint Violating Yak Guru
443 Posts |
Posted - 2002-04-04 : 01:40:27
|
when i have a duplicate row em will not delete the row...and i have many ok... let me try that i thought there should be some equalent to rowid...  thanks for info======================================Ask to your self before u ask someone |
|
|
|
|
|
|
Row id