The TOP clause further reduces the number of joined rows to the specified value. The TOP clause applies after the entire source table and the entire target table join and the joined rows that don't qualify for an insert, update, or delete action are removed. For more information, see TOP (Transact-SQL).
The rows referenced in the TOP expression aren't arranged in any order. expression can be either a number or a percentage of the rows. Specifies the number or percentage of affected rows. For more information, see WITH common_table_expression (Transact-SQL). The result set derives from a simple query and is referenced by the MERGE statement. Specifies the temporary named result set or view, also known as common table expression, that's defined within the scope of the MERGE statement.
The semi-colon is required, or the query will return a syntax error. | common_table_expression_name target_table ] Syntax for SQL Server and Azure SQL Database: ]
0 kommentar(er)
