Data Manipulation Language (DML) Update on SQLServer 2005

education dml sql server

in this article the author will discuss the use of Data Manipulation Language (DML) in SQLServer 2005.

to edit existing data in the table, we use the command update (DML) commands this update serves to

edit existing data in the table, especially used for users who need data changes

The update command is used to edit the data in the table

syntax for the command structure of the update is as follows:

UPDATE TABLE [Table Name] SET <Fieldname> = '<data baru>'

Examples of the use of DML update syntax:

T_user UPDATE TABLE SET name = 'admin'

To change the data with more than one field:

example:

T_user UPDATE TABLE SET name = 'admin', FullName = 'Fahmi'