INSERT (Transact-SQL)

Adds one or more rows to a table or a view in SQL Server. For examples, see Examples. ... WITH Specifies the temporary named result set, also known as common table expression, defined within the scope of the INSERT statement.

msdn.microsoft.com