Direct the OUTPUT of an UPDATE statement to a local variable
No, because you are potentially OUTPUT
ting multiple rows, which wouldn't fit into a scalar variable.
You need to output into a @Table
variable or declared table to handle multiple rows of output.