Even qualified DBAs can do this messup...

DELETE FROM <TABLE1>

WHERE a='X' -- OOPS... Forgot to select before I hit Execute

Ninja's_RGR'us (11/17/2011)

---

That's called a maintenance plan.

Backup, test the backups.

Keep the backups as long as necessary.

Shit happens, you can <mostly> prepare to repair the damage.

Change control management is an extra protection...

It would be truly impossible to ensure 100% that you have the exact order every single record is inserted into a table. You could devise more and more schemes but...

p-nut (11/17/2011)

---

Dev (11/17/2011)

---

So it seems that it is impossible to have a lower identity value and a later date when GETDATE() is in the insert statement. Got it!...

So it seems that it is impossible to have a lower identity value and a later date when GETDATE() is in the insert statement. Got it! Good info and thanks...

GilaMonster (11/17/2011)

---

It's got nothing to do with a difference of opinion.

It's got to do with someone who was posting blatantly incorrect advice (advising people to detach suspect databases, to delete...

@GS: In fact I was confused in first read later I figured that out when I saw ROFL, LOL, ETC 😀

Sean Lange (11/17/2011)

---

Dev (11/17/2011)

---

Ninja's_RGR'us (11/17/2011)

---

Tom Brown (11/17/2011)

---

It has to be oversized, have you seen his list of qualifications - not sure I understand most of them but...

Ninja's_RGR'us (11/17/2011)

---

Tom Brown (11/17/2011)

---

It has to be oversized, have you seen his list of qualifications - not sure I understand most of them but I'd like to be a...

All queries that have the standard form of SELECT select_list FROM clause WHERE clause are allowed. The INTO new_table_name clause of SELECT is not allowed when the new_table_name refers to...

Just one question Jared. Why do you want to discuss on this? Do you see any business requirement / Use Case where it could be useful?

The thread you referred to...

Thanks to Sean, Ninja & Brandie for sharing your views here. We always discuss about technology but I believe such discussions are equally important.

I will see what best I...

p-nut (11/17/2011)

---

Dev (11/17/2011)

---

Charmer (11/17/2011)

---

i want the last 5 rows based on last insertion...because i don't have any date time column...so how could i get it..?

more over my...

Gianluca Sartori (11/17/2011)

---

I didn't know this one. Can you please clarify what you mean...

Charmer (11/17/2011)

---

i want the last 5 rows based on last insertion...because i don't have any date time column...so how could i get it..?

more over my requirement is to get...