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

Why not join our community?, there are 6 users online

home
database
view story

DotNetKick.com is an open-source project. Please report any bugs and let us know your great suggestions. Currently running svn revision 620 (rss)

Kick Spy!, Kick Zeitgeist and Kick Widgets

15
kicks

kick it

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

published 1 year, 7 months ago, submitted by jgaylord 1 year, 7 months ago

weblogs.asp.net — 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: 1 | Get KickIt image code

tags: SQL, Database | tag it

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:

jgaylord - DonXml -

gavinjoyce - gsn1 - SQL_Menace - donthop -

JudahGabriel - jeremyh - csharpnjava - Ahmad - ashithmr - soma1988 -

j.monty - tmorton - jeremyholland

Comments:

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 jgaylord 1 year, 7 months ago

Here is a kick from me because I understand your pain

posted by SQL_Menace 1 year, 7 months ago