Transact-SQL 语法约定 语法 SQL Server 和 Azure SQL 数据库的语法: syntaxsql [WITH<common_table_expression>[,...n] ]MERGE[TOP( expression ) [PERCENT] ] [INTO]<target_table>[WITH(<merge_hint>) ] [ [AS]table_alias]USING[ [AS]table_alias]ON<merge_search_condition>[WHENMATCHED[AND<claus...
SyntaxSyntax for SQL Server and Azure SQL Database: syntaxsql Kopēt [ WITH <common_table_expression> [,...n] ] MERGE [ TOP ( expression ) [ PERCENT ] ] [ INTO ] <target_table> [ WITH ( <merge_hint> ) ] [ [ AS ] table_alias ] USING [ [ AS ] table_alias ] ON <...
Syntax for SQL Server and Azure SQL Database: syntaxsql Copy [ WITH <common_table_expression> [,...n] ] MERGE [ TOP ( expression ) [ PERCENT ] ] [ INTO ] <target_table> [ WITH ( <merge_hint> ) ] [ [ AS ] table_alias ] USING [ [ AS ] table_alias ] ON <merge_search...
In SQL Server 2008, you can perform insert, update, or delete operations in a single statement using the MERGE statement. The MERGE statement allows you to join a data source with a target table or view, and then perform multiple actions against the target based on the results of that join...
The OUTPUT clause returns a row for each row in the target that is inserted, updated, or deleted. For complete details on the syntax and rules, see MERGE (Transact-SQL). Specifying Source and Target Search Conditions It is important to understand how the source and target data are merged ...
Sintaxis de SQL Server y Azure SQL Database: syntaxsql [WITH<common_table_expression>[,...n] ]MERGE[TOP( expression ) [PERCENT] ] [INTO]<target_table>[WITH(<merge_hint>) ] [ [AS]table_alias]USING[ [AS]table_alias]ON<merge_search_condition>[WHENMATCHED[AND<clause_search_condition>...
适用于: SQL Server Azure SQL 托管实例 为订阅创建动态筛选分区,按订阅服务器上的HOST_NAME或SUSER_SNAME值进行筛选。 此存储过程是在发布服务器上发布的数据库中执行的,用于手动生成分区。 Transact-SQL 语法约定 语法 syntaxsql 复制 sp_addmergepartition [ @publication = ] ...
Transact-SQL 语法约定 语法 syntaxsql 复制 sp_helpmergepartition [ @publication = ] N'publication' [ , [ @suser_sname = ] N'suser_sname' ] [ , [ @host_name = ] N'host_name' ] [ ; ] 参数 [ @publication = ] N'publication' 发布的名称。 @publication 为sysname,...
In this article Syntax Arguments Return code values Remarks Show 4 more Applies to: SQL Server Changes the properties of a merge article. This stored procedure is executed at the Publisher on the publication database. Transact-SQL syntax conventions Syntax syntaxsql Copy sp_changemerge...
can be a derived table that uses the Transact-SQLtable value constructorto construct a table by specifying multiple rows. For more information about the syntax and arguments of this clause, seeFROM (Transact-SQL). ON <merge_search_condition> Specifies the conditions...