Deleting an Existing Row with DELETE Statements in SQL Server

Q

How To Delete an Existing Row with DELETE Statements in SQL Server?

✍: FYIcenter.com

A

If you want to delete an existing row from a table, you can use the DELETE statement with a WHERE clause to identify that row. Here is good sample of DELETE statements:

-- insert a row for this test
INSERT INTO fyi_links (url, id) 
   VALUES ('www.myspace.com', 301)
GO
(1 row(s) affected)

-- view the inserted row
SELECT id, url, notes, counts FROM fyi_links 
   WHERE id = 301
GO
id    url               notes   counts
301   www.myspace.com   NULL    NULL

-- delete one row
DELETE FROM fyi_links WHERE id = 301
GO
(1 row(s) affected)

-- try to view the deleted row
SELECT id, url, notes, counts FROM fyi_links 
   WHERE id = 301
no rows

Row with id of 301 is truly deleted.

 

Using INSERT, UPDATE and DELETE Statements in SQL Server

⇒⇒SQL Server Database Tutorials

2016-10-30, 639👍, 0💬