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, 3290🔥, 0💬
Popular Posts:
How To Fix the INSERT Command Denied Error in MySQL? The reason for getting the "1142: INSERT comman...
How To Update Multiple Rows with One UPDATE Statement in SQL Server? If the WHERE clause in an UPDAT...
What is sqlservr.exe - Process - SQL Server (SQLEX?PRESS) in SQL Server? Process sqlservr.exe is the...
How to download and install Microsoft .NET Framework Version 2.0 in SQL Server? .NET Framework Versi...
How To List All Login Names on the Server in SQL Server? If you want to see a list of all login name...