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, 1325🔥, 0💬
Popular Posts:
How To Select All Columns of All Rows from a Table with a SELECT statement in SQL Server? The simple...
How to download and install Microsoft .NET Framework Version 2.0 in SQL Server? .NET Framework Versi...
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...
How To Calculate DATETIME Value Differences Using the DATEDIFF() Function in SQL Server Transact-SQL...
How To Download Oracle Database 10g XE in Oracle? If you want to download a copy of Oracle Database ...