How To Update Values in a Table with UPDATE Statements in MS SQL Server?
Submitted by: AdministratorIf 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.
Submitted by: Administrator
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.
Submitted by: Administrator
Read Online MS SQL Server Job Interview Questions And Answers
Top MS SQL Server Questions
| ☺ | How To Start SQL Server Browser Service? |
| ☺ | What Happens If NULL Values Are Involved in Arithmetic Operations? |
| ☺ | How To Execute the Cursor Queries with "OPEN" Statements? |
| ☺ | What Happens If Strings Are Casted into Wrong Code Pages in MS SQL Server? |
| ☺ | How to Create a View using Data from Another View? |
Top Databases Programming Categories
| ☺ | RDBMS Interview Questions. |
| ☺ | SQL Interview Questions. |
| ☺ | SSRS Interview Questions. |
| ☺ | Database Administrator (DBA) Interview Questions. |
| ☺ | Sybase Interview Questions. |
