MS SQL
Oracle
DB2
Access
MySQL
PostgreSQL
Sybase
PHP
SQL Etc
SQL Scripts & Samples
Links
Database Forum
Register
Help
Remember Me?
Forum
New Posts
FAQ
Calendar
Forum Actions
Mark Forums Read
Quick Links
Today's Posts
View Site Leaders
What's New?
Advertiser Disclosure
Advanced Search
Forum
Miscellaneous
Ask an Expert
how to delete duplicate rows in sql server 2000
If this is your first visit, be sure to check out the
FAQ
by clicking the link above. You may have to
register
before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.
Results 1 to 2 of 2
Thread:
how to delete duplicate rows in sql server 2000
Thread Tools
Show Printable Version
Email this Page…
Display
Switch to Linear Mode
Switch to Hybrid Mode
Threaded Mode
Threaded View
Previous Post
Next Post
12-12-2006,
09:39 AM
#2
rmiao
View Profile
View Forum Posts
Registered User
Join Date
Sep 2002
Posts
5,938
One way can try is set rowcount = 1 then run delete statement.
Reply With Quote
Quick Navigation
Ask an Expert
Top
Site Areas
Settings
Private Messages
Subscriptions
Who's Online
Search Forums
Forums Home
Forums
Database Discussions
IBM DB2
Informix
Microsoft Access
Microsoft SQL Server 2008
Microsoft SQL Server 2005
MDX and Analysis Services
Reporting Services
MS SQL Server 7/MS SQL Server 2000
MySQL
Oracle
PostgreSQL
Sybase
Miscellaneous
General Database Discussions
Ask an Expert
Database Design
Database Programming
Database News and Announcements
Structured Query Language (SQL)
SQL Scripts
Database Lounge
Feedback
Related Sites
SQL Course
SqlCredit
«
Previous Thread
|
Next Thread
»
Posting Permissions
You
may not
post new threads
You
may not
post replies
You
may not
post attachments
You
may not
edit your posts
BB code
is
On
Smilies
are
On
[IMG]
code is
Off
[VIDEO]
code is
Off
HTML code is
Off
Forum Rules
Reply With Quote