juniorT-SQL

What is UPDATE statement?

Updated May 17, 2026

Short answer

UPDATE modifies existing records.

Deep explanation

It changes data in rows matching conditions.

Real-world example

Updating employee salary.

Common mistakes

  • Missing WHERE causing full table update.

Follow-up questions

  • Can UPDATE be rolled back?
  • Is UPDATE logged?

More T-SQL interview questions

View all →