How to modify data using Update in Microsoft SQL Server

Let's go with steps as usual - Open New Query - Write the SQL command with replacing the variables according to yours UPDATE TableName SET Value1 = '......', Value2= '......' , etc WHERE Condition example: WHERE emp_id= '1' - Left click on Execute button Your data has been updated successfully and I hope you enjoyed watching the video :) Notes: the condition is determine which row will be affected by the new values that you've entered into Update SQL command.