#sql server update statement

The SQL UPDATE statement is used to modify the data in the tables.You can use the WHERE clause with the update query to update the selected rows, otherwise all lines will be affected. Syntax UPDATE tablename SET column1 = value1, column2 = value2, ... WHERE condition   Example UPDATE students SET nickname = 'Rathore' WHERE id = '5' This is a example table and the table name is…