MS SQL Server Concepts and Programming Question: Download MS SQL Server PDF
How To Update Values in a Table with UPDATE Statements in MS SQL Server?
Answer:
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 ggl_links WHERE id = 101
GO
id url notes counts created
101 www.globalguideline.com NULL 0 2006-04-30
UPDATE ggl_links SET counts = 999, notes = 'Good.'
WHERE id = 101;
GO
(1 row(s) affected)
SELECT * FROM ggl_links WHERE id = 101
GO
id url notes counts created
101 www.globalguideline.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.
SELECT * FROM ggl_links WHERE id = 101
GO
id url notes counts created
101 www.globalguideline.com NULL 0 2006-04-30
UPDATE ggl_links SET counts = 999, notes = 'Good.'
WHERE id = 101;
GO
(1 row(s) affected)
SELECT * FROM ggl_links WHERE id = 101
GO
id url notes counts created
101 www.globalguideline.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.
| Previous Question | Next Question |
| How To Insert Multiple Rows with One INSERT Statement in MS SQL Server? | How To Update Multiple Rows with One UPDATE Statement in MS SQL Server? |