create alias table in sql server update code example

Example: sql update alias

UPDATE t
SET t.COLUMN = 'UPDATE'
FROM DATABASE_TABLE t
WHERE t.ID = 1;