Update

UPDATE Allows us to update a set of data in a table that can be specified by the WHERE criteria.

UPDATE My_Table
SET <Column1> = [updated_value1]
	,<Column2> = [updated_value2]
	,[...]
WHERE <filter(s)> (Optional)

So in essence:

BEGIN TRAN
UPDATE database.schema.table
SET Misc = 'Fourth'
OUTPUT Inserted.*
WHERE ID = 4

SELECT * FROM database.schema.table
ROLLBACK COMMIT

• Uses elements:
  • Begin Transaction
  • T-SQL Rollback
  • T-SQL Commit
  • OUTPUT

---

Children

1. Example

---

Backlinks

• Common Table Expressions (DevLog)
• Data Manipulation Language (DevLog)