MS SQL Server Concepts and Programming Question: Download Questions 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.
Download MS SQL Server Interview Questions And Answers
PDF
| 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? |