Collections:
Updating Multiple Rows with One UPDATE Statement in SQL Server
How To Update Multiple Rows with One UPDATE Statement in SQL Server?
✍: FYIcenter.com
If the WHERE clause in an UPDATE statement matches multiple rows, the SET clause will be applied to all matched rows. This rule allows you to update values on multiple rows in a single UPDATE statement. Here is a good example:
SELECT * FROM fyi_links WHERE id >= 500 GO id url notes counts created 601 moc.retneciyf.ved NULL 0 2006-04-30 602 moc.retneciyf.abd NULL 0 2007-05-19 603 moc.retneciyf.aqs NULL NULL 2007-05-19 SELECT * FROM fyi_links UPDATE fyi_links SET counts = 9, notes = 'Wrong' WHERE id >= 500 (3 row(s) affected) SELECT * FROM fyi_links WHERE id >= 500 GO id url notes counts created 601 moc.retneciyf.ved Wrong 9 2006-04-30 602 moc.retneciyf.abd Wrong 9 2007-05-19 603 moc.retneciyf.aqs Wrong 9 2007-05-19
The UPDATE statement updated 3 rows with the same new values.
⇒ Using Old Values to Define New Values in UPDATE Statements in SQL Server
⇐ Updating Values with UPDATE Statements in SQL Server
2016-11-02, 3422🔥, 0💬
Popular Posts:
How To Create a Dynamic Cursor with the DYNAMIC Option in SQL Server Transact-SQL? If the underlying...
Where to find answers to frequently asked questions on Downloading and Installing SQL Server 2005 Ex...
How To Convert Numeric Expression Data Types using the CAST() Function in SQL Server Transact-SQL? I...
Where to find answers to frequently asked questions on Conditional Statements and Loops in SQL Serve...
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...