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 |
|
rtutus
Aged Yak Warrior
522 Posts |
 Posted - 2006-12-03 : 14:36:30
|
| If we want to remove the duplicate row and leave only one row instead of 2 or 3 rows for example with the same column values.2/ The same question but when all the columns of the row are duplicate except the id field.Thanks a lot. |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-12-03 : 15:42:28
|
http://support.microsoft.com/kb/139444Go with the flow & have fun! Else fight the flow  blog thingie: http://weblogs.sqlteam.com/mladenp |
 |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2006-12-03 : 16:54:27
|
| The 1 in 101 database design:Make sure tables have proper UNIQUE CONSTRAINTS!wtf, MS even has a knowledge base article on this!rockmoose |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-12-04 : 04:24:42
|
yeah i thought that exact same thought...well better be prepared, right?  Go with the flow & have fun! Else fight the flow blog thingie: http://weblogs.sqlteam.com/mladenp |
|
|
|
|
|
|
is there a way to remove table rows duplicates