Deleting Multiple Rows with One DELETE Statement in SQL Server

Q

How To Delete Multiple Rows with One DELETE Statement in SQL Server?

✍: FYIcenter.com

A

You can delete multiple rows from a table in the same way as deleting a single row, except that the WHERE clause will match multiple rows. The tutorial exercise below deletes 3 rows from the fyi_links table:

-- view rows to be deleted
SELECT id, url, notes, counts FROM fyi_links 
   WHERE id > 300
GO
id    url               notes   counts
801  moc.retneciyf.ved  Wrong  1202
802  moc.retneciyf.abd  Wrong  1204
803  moc.retneciyf.aqs  Wrong  1206

-- delete multiple rows
DELETE FROM fyi_links WHERE id > 300
GO
(3 row(s) affected)

-- try to view the deleted row
SELECT id, url, notes, counts FROM fyi_links 
   WHERE id > 300
GO
no rows

 

Deleting All Rows with DELETE Statements in SQL Server

Deleting an Existing Row with DELETE Statements in SQL Server

Using INSERT, UPDATE and DELETE Statements in SQL Server

⇑⇑ SQL Server Database Tutorials

2016-10-30, 1322🔥, 0💬