Collections:
Deleting an Existing Row with DELETE Statements in SQL Server
How To Delete an Existing Row with DELETE Statements in SQL Server?
✍: FYIcenter.com
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, 1783🔥, 0💬
Popular Posts:
How To Insert New Line Characters into Strings in SQL Server Transact-SQL? If you want to break a st...
What Happens If the UPDATE Subquery Returns Multiple Rows in SQL Server? If a subquery is used in a ...
How To Calculate DATETIME Value Differences Using the DATEDIFF() Function in SQL Server Transact-SQL...
How To Provide Default Values to Function Parameters in SQL Server Transact-SQL? If you add a parame...
How To Convert Numeric Expression Data Types using the CAST() Function in SQL Server Transact-SQL? I...