UPDATE (Transact-SQL) - SQL Server | Microsoft Learn
https://learn.microsoft.com/en-us/sql/t-sql/queries/update-transact-sql?view=sql-server-ver16
-- Syntax for SQL Server and Azure SQL Data…[ WITH <common_table_expression> [...n] ] [ TOP ( expression ) [ PERCENT ] ]{ { table_alias | <object> | rowset_function_limited [ WITH ( <Table_Hint_Limited> [ ...n ] ) ]{ column_name = { expression | DEFAULT | NULL }
-- Syntax for SQL Server and Azure SQL Data…[ WITH <common_table_expression> [...n] ]
[ TOP ( expression ) [ PERCENT ] ]{ { table_alias | <object> | rowset_function_limited
[ WITH ( <Table_Hint_Limited> [ ...n ] ) ]{ column_name = { expression | DEFAULT | NULL }
DA: 23 PA: 96 MOZ Rank: 7