Home » SQL Server » SQL Server UPDATE Statement

SQL Server UPDATE Statement

Update Query Example

The SQL Server UPDATE Statement is used to modify existing data in table. It’s comes under Data Manipulation Language(DML).

Syntax:

UPDATE table_name SET column1 = value1,
column2 = value2,...columnN = valueN 
WHERE condition

Note: See how to CREATE TABLE & INSERT Data into Table

Example:

Select Data in SQL

Select Data in SQL

Now we will update firstName & lastName for IdentityNo ‘A100’.



Execute below query:

 UPDATE tblemp2 SET firstName='Roy', lastName='Mike' WHERE IdentityNo='A100'

Query Output:

Query Result

Hope you enjoy the post. Your valuable feedback, question, or comments about this post are always welcome or you can leave us message on our contact form , we will revert to you asap.

Recommended SQL Server Post:

SQL CREATE TABLE 

SQL INSERT INTO

SQL Server Commands

Leave a Reply