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.
⇒ Deleting Multiple Rows with One DELETE Statement in SQL Server
⇐ UPDATE Subquery Returning Multiple Rows in SQL Server
2016-10-30, 2027🔥, 0💬
Related Topics:
