|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
April 12th, 2004, 09:43 AM
|
|||
|
|||
Deleting record from Table
Hey Guys,
I have two similar records in a table. I need to delete only one record out of two. How do I do this using SQL Query Analyser ? With Best Regards, Sufiyan
|
|
#2
April 12th, 2004, 11:57 AM
|
|||
|
|||
|
Hi,
Please try this. First locate something in the row that you want to delete that is unique. Then run this script. USE DBname DELETE FROM DBTable WHERE ( There where clause identifies the uniqeness that you found) Then press "Shift" "F5" and if everything is alright the "F5". Ubique !
|
|
#4
April 13th, 2004, 01:05 AM
|
||||
|
||||
|
Delete both and then insert one back in.
As an aside, you may want to enforce a unique constraint on this table so that you have some way of identifying a single row.
__________________
Up the Irons What Would Jimi Do? Smash amps. Burn guitar. Take the groupies home. "Death Before Dishonour, my Friends!!" - Bruce D ickinson, Iron Maiden Aug 20, 2005 @ OzzFest Down with Sharon Osbourne Puzzle of the Month solved by Keath and KevinADC, superior perl programmers of the month
|
|
| Viewing: Dev Shed Forums > Databases > MS SQL Development > Deleting record from Table |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
