Update output-clause-transact-sql.md

erikdarlingdata · rwestMSFT · commit 0a9c8b75ed1e · 2023-04-10T15:47:28.000-06:00
Add a note to the parallelism section about table variables.
diff --git a/docs/t-sql/queries/output-clause-transact-sql.md b/docs/t-sql/queries/output-clause-transact-sql.md
@@ -204,7 +204,7 @@ DELETE Sales.ShoppingCartItem
 -   In the \<dml_table_source> clause, the SELECT and WHERE clauses cannot include subqueries, aggregate functions, ranking functions, full-text predicates, user-defined functions that perform data access, or the TEXTPTR function.  
 
 ## Parallelism
- An OUTPUT clause that returns results to the client will always use a serial plan.
+ An OUTPUT clause that returns results to the client or table variable will always use a serial plan.
 
 In the context of a database set to compatibility level 130 or higher, if an INSERT...SELECT operation uses a WITH (TABLOCK) hint for the SELECT statement and also uses OUTPUT...INTO to insert into a temporary or user table, then the target table for the INSERT...SELECT will be eligible for parallelism depending on the subtree cost.  The target table referenced in the OUTPUT INTO clause will not be eligible for parallelism. 
  
