When UPDATE statements DELETE rows!

preview_player
Показать описание
I was shocked to discover that SQL Server was deleting certain rows when I ran an UPDATE statement...or at least that's what I *thought* was happening.

Check out the related blog post for all code samples:

Follow me on Twitter:
  1. Bert Wagner
  2. SQL Server
  3. SQL
  4. update statement
  5. delete statement
  6. sql bug
Рекомендации по теме
When UPDATE statements 0:03:47

When UPDATE statements DELETE rows!

Update & Delete 0:05:14

Update & Delete Using Join | How to Update and Delete Record Using Join | Intellipaat

MySQL - Update 0:26:11

MySQL - Update and Delete Records (update, delete)

SQL MERGE | 0:07:01

SQL MERGE | How to insert, update and delete rows in a table using one SQL query

SQL Tutorial for 0:06:20

SQL Tutorial for Beginners 5: UPDATE and DELETE - Modifying and Removing Records from Your Database

Learn How to 0:03:39

Learn How to Delete Data Rows using Delete Statement in SQL

How to insert 0:04:22

How to insert and delete rows in views in SQL server manager

Delete All Blank 0:00:39

Delete All Blank Rows in Excel Entire Row @BrainUpp

#FabricCoffee | Michael 1:15:32

#FabricCoffee | Michael Washington | Using Blazor to Manage Data in SQL Server and Microsoft Fabric

Delete a row 0:01:27

Delete a row from a table: SQL Training by SQLSteps

Delete Empty Rows 0:00:26

Delete Empty Rows with these Excel Shortcuts #shorts

How To Delete 0:01:00

How To Delete the rows from a table randomly #sqlserver

Delete all rows 0:02:39

Delete all rows and truncate statements in Sql server

DML Statements | 0:10:04

DML Statements | How to Insert, Update and Delete Row(Data) in SQL | SQL Lecture 10 | #oracle #sql

#SQL Two Ways 0:00:35

#SQL Two Ways to Delete Rows #datascience

Part 4 0:03:26

Part 4 Delete duplicate rows in sql

How to Delete 0:00:40

How to Delete Blank Rows in Excel ? | Excel Tips & Tricks #shorts

SQL Tutorial for 0:15:24

SQL Tutorial for beginners: (2) INSERT, UPDATE and DELETE records in a table using SQLite3

Ignore Top 5 0:00:59

Ignore Top 5 or 'N' Rows Delete Rest Of The Rows Table #sqlserver

Changing rows with 0:04:33

Changing rows with UPDATE and DELETE | Computer Programming | Khan Academy

How to Update 0:15:14

How to Update and Delete a Row in SQL

Delete All The 0:00:44

Delete All The Rows From Table Except Specific Rows or IDs #sqlserver

How to delete 0:02:13

How to delete a row using Sql in MySql Workbench

Oracle APEX Tutorial 0:05:06

Oracle APEX Tutorial 03 - Select, Insert, Update, and Delete Rows in a Table Using SQL

Комментарии
Автор

I guess it would behave the same way for other columns which are not primary key. The title is misleading though as nothing got deleted

ankushmankar
Автор

Easy mistake to make given the poor column names! Just a bad update statement though, nothing is actually getting deleted!

Sttuey
Автор

lol, I didn't catch that either.

There was one time a couple years ago that I came across a bug in SQL Server. That was the last thing I thought would have happened. It took someone else confirming it was a bug (on stack exchange) before I finally submitted a bug to the SQL Server team. I was a bit flabbergasted that I had find a bug with SQL Server, a rare occurrence!

dovh