Thursday 10 March 2016

UPDATE Keyword

UPDATE keyword is used to update the records already in the database. Where caluse should always be specifed to update the existing record as this may even create column or data lock.

Example

Update EMP_Database
Set EMP_NAME = 'Ramneek'
Where EMP_NAME='Rakesh'


This query will update EMP_NAME as Ramneek Where EMP_Name as Rakesh

No comments:

Post a Comment