For more information, see DECLARE CURSOR (Transact-SQL). You can use the compound assignment operator anywhere you have an assignment with an expression on the right-hand side of the operator, ...

"Table Variable Deferred Compilation (TVDC) improves plan quality and overall performance for queries that reference table variables. TVDC is a feature under the ...