Basic Structure of Query
UPDATE table_name
SET column1 = value1, column2 = value2, ...and so on total no of values
WHERE condition;
UPDATE table_name
SET column1 = value1, column2 = value2, ...and so on total no of values
WHERE condition;
Top 100+ Sql Server Interview Questions
Note :- Where Condition is mandatory, if misses then all rows of table will be replaced with value.
Demo Query:=
UPDATE Student
SET Student_Name = 'Sawan Chauhan', City= 'Delhi'
WHERE Student_ID = 1;
No comments:
Post a Comment