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:-



Update query in SQL Server Update query in SQL Server Reviewed by NEERAJ SRIVASTAVA on 11:01:00 AM Rating: 5

No comments:

Powered by Blogger.