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, 1318🔥, 0💬
Popular Posts:
What Happens If the UPDATE Subquery Returns Multiple Rows in SQL Server? If a subquery is used in a ...
How to continue to the next iteration of a WHILE loop in SQL Server Transact-SQL? How to use CONTINU...
How To Verify Your PHP Installation in MySQL? PHP provides two execution interfaces: Command Line In...
What Is an Oracle Instance in Oracle? Every running Oracle database is associated with an Oracle ins...
How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need ...