sys.sp_copy_data_in_batches (Transact-SQL)
Applies to: SQL Server 2022 (16.x) Azure SQL Database
Copies data from the source table to the target table after verifying that their schema is identical in terms of number of columns, column names and their data types. TRANSACTION ID
, SEQUENCE NUMBER
, and GENERATED ALWAYS
columns are ignored since they're system generated and this allows copying data from a regular table to a ledger table and vice versa. Indexes between the tables can be different but the target table can only be a heap or have a clustered index. The data is copied in batches in individual transactions. If the operation fails, the target table is partially populated.
For more information on database ledger, see Ledger.
Transact-SQL syntax conventions
Syntax
sp_copy_data_in_batches
[ @source_table_name = ] N'source_table_name'
, [ @target_table_name = ] N'target_table_name'
Arguments
[ @source_table_name = ] N'source_table_name'
The name of the table to be used as the source of the data copy.
[ @target_table_name = ] N'target_table_name'
The name of the table to be used as the target of the data copy.
Return code values
0 (success)
Result set
None.
Permissions
This operation requires SELECT on the source table, INSERT in the target table, and ALTER on the target table if there are foreign key or check constraints that will be disabled, or an identity column that will be adjusted.
Related content
Povratne informacije
https://aka.ms/ContentUserFeedback.
Stiže uskoro: Tokom 2024. godine postepeno ćemo ukidati probleme sa uslugom GitHub kao mehanizam povratnih informacija za sadržaj i zameniti ga novim sistemom povratnih informacija. Dodatne informacije potražite u članku:Prosledite i prikažite povratne informacije za