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

 

Using INSERT, UPDATE and DELETE Statements in SQL Server

⇒⇒SQL Server Database Tutorials

2016-10-30, 641👍, 0💬