sql update alias
snippet in sql

sql update alias

user9249

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