|
I meant to delete five rows from a table and wrote very quickly this
delete dbo.tblXYZ
where ID >= 116 or ID <= 120
ended blowing the whole table away. Talk about blowing your feet off
I know, I know it should have been AND not OR, it is too late now. 
UPDATE: I have a backup, but lost a hour worth of work...
modified 14-May-14 15:59pm.
|
|
|
|
|
Ummm, is "I didn't do it" an option? If not, run, run away.
|
|
|
|
|
I'm the sole creator and maintainer of the data. No where to run
|
|
|
|
|
To avoid such problems, I usually substitute a SELECT query using the desired conditional clause to see what records will be affected BEFORE executing the DELETE query.
I hope it wasn't anything you can't recreate!
The difficult we do right away...
...the impossible takes slightly longer.
|
|
|
|
|
Real men do not care. They simply run the query.
And then in middle of night they restore the backup that they did before running the query.
|
|
|
|
|
Let's hope the OP had a backup. 
The difficult we do right away...
...the impossible takes slightly longer.
|
|
|
|
|
I had a backup, but lost lost an hour worth of work, which is not bad considering the size of the table
|
|
|
|
|
being real man cost me my sleep 
|
|
|
|
|
I do the same thing for an update as well, I may not qualify as a real man but I don't trash table these days.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
You had backups of course?
Along with Antimatter and Dark Matter they've discovered the existence of Doesn't Matter which appears to have no effect on the universe whatsoever!
Rich Tennant 5th Wave
|
|
|
|
|
what backup? Real men don't backup 
I do, but lost an hour worth of work, which is not bad considering the size of the table if I didn't backup
|
|
|
|
|
Backup as in a bucket of 1s and 0s, in a logical order of course.
Along with Antimatter and Dark Matter they've discovered the existence of Doesn't Matter which appears to have no effect on the universe whatsoever!
Rich Tennant 5th Wave
|
|
|
|
|
That's what you use BETWEEN for. Less ambiguity.
|
|
|
|
|
Klingon developers like bold personalities like yours.
Yusuf wrote: UPDATE: I have a backup, but lost a hour worth of work...
Some man points gone away...
Veni, vidi, vici.
|
|
|
|
|
FTFY
CPallini wrote: Some man Klingon points gone away...
|
|
|
|
|
Have a template that says "START TRANSACTION" at the top; that way you can always rollback or commit your command.
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
|
Yes? May I help you?
I also told you never to call me that.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
So...you joined today. Welcome aboard. Enjoy, sit down, call the cat an Elephant.
I know it may not seem like it, but most of the messages in the Lounge make sense. The exceptions being anything posted by DD after about 22:00 GMT, and pretty much anything by BlueWaffle or me. Or MM after the pubs open. Or Nagy, come to think of it.
So try to avoid messages like "wat up with you" and a series of winking icons, as they will not make you any friends.
Those who fail to learn history are doomed to repeat it. --- George Santayana (December 16, 1863 – September 26, 1952)
Those who fail to clear history are doomed to explain it. --- OriginalGriff (February 24, 1959 – ∞)
|
|
|
|
|
OriginalGriff wrote: The exceptions being anything posted by DD after about 22:00 GMT, and pretty much anything by BlueWaffle or me. Or MM after the pubs open. Or Nagy, come to think of it.
So... 90% of Lounge content?
What is this talk of release? I do not release software. My software escapes leaving a bloody trail of designers and quality assurance people in its wake.
|
|
|
|
|
Do not trust the walrus.
The salmon run is late this year.
I hear the cuckoos are mating in the Appalachians.
|
|
|
|
|
harold aptroot wrote: The salmon run is late this year.
"late"?
"late"?
Sure you are? Not "pink"?
Elephant! Come with me, if you want to live.
Those who fail to learn history are doomed to repeat it. --- George Santayana (December 16, 1863 – September 26, 1952)
Those who fail to clear history are doomed to explain it. --- OriginalGriff (February 24, 1959 – ∞)
|
|
|
|
|
But wait, shouldn't we get the microfilm?
|
|
|
|
|
Member007 is on it.
Those who fail to learn history are doomed to repeat it. --- George Santayana (December 16, 1863 – September 26, 1952)
Those who fail to clear history are doomed to explain it. --- OriginalGriff (February 24, 1959 – ∞)
|
|
|
|
|
007[^] hasn't made contact since going to Kiev.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
