Daily WTF - Deleting SQL Data (or Properly Formatting SQL)

home
database
view story

15 Kicks

Daily WTF - Deleting SQL Data (or Properly Formatting SQL)(weblogs.asp.net)

submitted by jgaylord(475) 5 years, 1 month ago

Have you ever had a really bad day (or week) where you miss the most obvious mistakes? Well, this is one of the worst -- improper SQL statements deleting all of the data from a table.

2 comments |category: Database |Views: 6
Tweet

tags: SQL Database another

Everyones tags:

Your Tags:

Please login or signup.

Add a live kick counter to your blog >> liveImage

You can even customize the image by choosing your own colors, and then clicking the button below to update the preview and the html code:

"Kick It" text
"Kick It" background
kick count text
kick count background
border

Simply copy and paste this HTML into your blog post.

Users who kicked this story:

jeremyholland(0) -

tmorton(0) -

j.monty(1868) -

soma1988(0)

More who kicked this story...

Comments:

posted by jgaylord(475) 5 years, 1 month ago 0

By jgaylord:

"We've been having an issue with one of our database tables' mysteriously deleting data at random. We could have *swore* it was some sort of SQL intrusion or code bug. We leaned towards SQL intrusion because this database has been in use for quite some time. However, that was not the case. A new Stored Procedure that touched this table was added recently. In quick review, it didn't appear that anything was wrong. Click the title above for the code sample..."

posted by SQL_Menace(4890) 5 years, 1 month ago 0

Here is a kick from me because I understand your pain

Most Active Users

What's this?