Update query in SQL Server

Syntax:-

Update table set  columname1=value1, columnname2=value2 where columname = value

Explanation:-

Table::-

Query:-

update reg set Name='Neeraj',Gender='Male' where Email='srinickraj@gmail.com'

using the above query we can update the name , gender where email is srinickraj@gmail.com

output:-