Insert into a row variable

You cannot insert to a row variable by using an INSERT statement. The row variable represents a single table row in the form of a collection-derived table. Each field in the row type is like a column in this virtual table. returns an error if you attempt to insert to a row variable.

You can, however, use the UPDATE statement to insert new field values into a row variable.