Not a good day to end the day.
-
I meant to delete five rows from a table and wrote very quickly this
delete dbo.tblXYZ
where ID >= 116 or ID <= 120ended blowing the whole table away. Talk about blowing your feet off I know, I know it should have been
ANDnotOR, it is too late now. :-O UPDATE: I have a backup, but lost a hour worth of work...Yusuf May I help you?
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.
-
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.
My CP workspace: Incredibly trivial and probably useless code samples[^]
-
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.
My CP workspace: Incredibly trivial and probably useless code samples[^]
Let's hope the OP had a backup. :)
The difficult we do right away... ...the impossible takes slightly longer.
-
I meant to delete five rows from a table and wrote very quickly this
delete dbo.tblXYZ
where ID >= 116 or ID <= 120ended blowing the whole table away. Talk about blowing your feet off I know, I know it should have been
ANDnotOR, it is too late now. :-O UPDATE: I have a backup, but lost a hour worth of work...Yusuf May I help you?
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
-
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
Yusuf May I help you?
-
I meant to delete five rows from a table and wrote very quickly this
delete dbo.tblXYZ
where ID >= 116 or ID <= 120ended blowing the whole table away. Talk about blowing your feet off I know, I know it should have been
ANDnotOR, it is too late now. :-O UPDATE: I have a backup, but lost a hour worth of work...Yusuf May I help you?
That's what you use
BETWEENfor. Less ambiguity.Wrong is evil and must be defeated. - Jeff Ello[^]
-
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.
My CP workspace: Incredibly trivial and probably useless code samples[^]
being real man cost me my sleep ;P
Yusuf May I help you?
-
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
-
Ummm, is "I didn't do it" an option? If not, run, run away.
My CP workspace: Incredibly trivial and probably useless code samples[^]
I'm the sole creator and maintainer of the data. No where to run :-O
Yusuf May I help you?
-
what backup? Real men don't backup :doh: I do, but lost an hour worth of work, which is not bad considering the size of the table if I didn't backup
Yusuf May I help you?
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
-
I meant to delete five rows from a table and wrote very quickly this
delete dbo.tblXYZ
where ID >= 116 or ID <= 120ended blowing the whole table away. Talk about blowing your feet off I know, I know it should have been
ANDnotOR, it is too late now. :-O UPDATE: I have a backup, but lost a hour worth of work...Yusuf May I help you?
-
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.
-
I meant to delete five rows from a table and wrote very quickly this
delete dbo.tblXYZ
where ID >= 116 or ID <= 120ended blowing the whole table away. Talk about blowing your feet off I know, I know it should have been
ANDnotOR, it is too late now. :-O UPDATE: I have a backup, but lost a hour worth of work...Yusuf May I help you?
-
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.
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
