How to Update Data of Database Table in SQL

In this article I am going to explain about how to update data in database.
  • 1777

Introduction

In this article I am going to explain about how to update data in database. We use UPDATE statement to to update data in table or database. This statement is part of DML (Data Manipulation Language). There are many situation when we need to update data in database.  To update data in database we also put some condition in update statement.

Fallowing Statement fetch data from mcnemp table

Clipboard02.jpg

Fallowing Statement update data in mcnemp table

Clipboard04.jpg

An Fallowing Statement update data in mcnemp table

Clipboard06.jpg

Fallowing Statement fetch data from mcnemp table

Clipboard08.jpg

© 2013 dotNetheaven. All rights reserved.