Specifies the temporary named result set, also known as common table expression, defined within the scope of the INSERT statement. The result set is derived from a SELECT statement. For more ...

database_name Is the database name in which the specified table or view resides. If not specified, this is the current database. table_name Is the name of the table or view to bulk import data into.