Collections:
Using Old Values to Define New Values in UPDATE Statements in SQL Server
How to use old values to define new values in UPDATE statements in SQL Server?
✍: FYIcenter.com
If a row matches the WHERE clause in a UPDATE statement, existing values in this row can be used in expressions to provide new values in the SET clause. Existing values are represented by column names in the expressions. The tutorial exercise below shows you a good example:
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-21 603 moc.retneciyf.aqs Wrong 9 2007-05-23 UPDATE fyi_links SET id = id+200, counts = id*2 WHERE id >= 500 GO (3 row(s) affected) SELECT * FROM fyi_links WHERE id >= 500 GO id url notes counts created 801 moc.retneciyf.ved Wrong 1202 2006-04-30 802 moc.retneciyf.abd Wrong 1204 2007-05-19 803 moc.retneciyf.aqs Wrong 1206 2007-05-19
This statement increased values in the id column by 200. It also updated the counts column with the newly increased id value.
2016-11-02, 602👍, 0💬
Popular Posts:
What Happens If the UPDATE Subquery Returns Multiple Rows in MySQL? If a subquery is used in a UPDAT...
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...
Where to find answers to frequently asked questions on Oracle basic concepts? I am new to Oracle dat...
How To Convert Numeric Values to Integers in SQL Server Transact-SQL? Sometimes you need to round a ...
What Do You Need to Connect PHP to MySQL in MySQL? If you want to access MySQL database server in yo...