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, 1309🔥, 0💬
Popular Posts:
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and ...
What Happens If the UPDATE Subquery Returns Multiple Rows in MySQL? If a subquery is used in a UPDAT...
What are single-byte character string data types supported in SQL Server Transact-SQL? Single-byte c...
What are single-byte character string data types supported in SQL Server Transact-SQL? Single-byte c...
What Is Program Global Area (PGA) in Oracle? A Program Global Area (PGA) is a memory buffer that is ...