SQL Server - Updating Values with UPDATE Statements in SQL Server

Updating Values with UPDATE Statements in SQL Server

Q

How To Update Values in a Table with UPDATE Statements in SQL Server?

✍: FYIcenter.com

A

If you want to update some values in one row or multiple rows in a table, you can use the UPDATE statement. The tutorial script below shows a good example:

SELECT * FROM fyi_links WHERE id = 101
GO
id      url                     notes   counts  created
101     dev.fyicenter.com       NULL    0       2006-04-30

UPDATE fyi_links SET counts = 999, notes = 'Good.' 
   WHERE id = 101;
GO
(1 row(s) affected)

SELECT * FROM fyi_links WHERE id = 101
GO
id      url                     notes   counts  created
101     dev.fyicenter.com       Good.   999     2006-04-30

As you can see, the SET clause takes column and value pairs to provide new values, while the WHERE clause defines which row to apply the update.

⇒Using INSERT, UPDATE and DELETE Statements in SQL Server

⇒⇒SQL Server Database Tutorials

2016-11-02, 659👍, 0💬

Inserting Multiple Rows with One INSERT Statement in SQL Server
How To Insert Multiple Rows with One INSERT Statement in SQL Server? If you want to insert multiple rows with a single INSERT statement, you can use a subquery instead of the VALUES clause. Rows returned from the subquery will be inserted the target table. The following tutorial exercise gives you a... 2016-11-02, 673👍, 0💬

Updating Values with UPDATE Statements in SQL Server
How To Update Values in a Table with UPDATE Statements in SQL Server? If you want to update some values in one row or multiple rows in a table, you can use the UPDATE statement. The tutorial script below shows a good example: SELECT * FROM fyi_links WHERE id = 101 GO id url notes counts created 101 ... 2016-11-02, 660👍, 0💬

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? 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. ... 2016-11-02, 601👍, 0💬

Updating Multiple Rows with One UPDATE Statement in SQL Server
How To Update Multiple Rows with One UPDATE Statement in SQL Server? 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: SELE... 2016-11-02, 551👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.