Skip to content

Commit fe7b8f4

Browse files
authored
Update insert-transact-sql.md
1 parent 650672a commit fe7b8f4

File tree

1 file changed

+3
-2
lines changed

1 file changed

+3
-2
lines changed

docs/t-sql/statements/insert-transact-sql.md

Lines changed: 3 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -315,6 +315,7 @@ However, starting with [!INCLUDE[ssSQL15](../../includes/sssql15-md.md)] and dat
315315
Parallelism for the statement above has the following requirements, which are similar to the requirements for minimal logging:
316316
- The target table is an empty or non-empty heap.
317317
- The target table has a clustered columnstore index (CCI) but no non-clustered indexes.
318+
- The target table does not have an identity column with IDENTITY_INSERT set to OFF.
318319
- The `TABLOCK` hint is specified for the target table.
319320

320321
For scenarios where requirements for minimal logging and parallel insert are met, both improvements will work together to ensure maximum throughput of your data load operations.
@@ -406,9 +407,9 @@ In Parallel Data Warehouse, the ORDER BY clause is invalid in VIEWS, CREATE TABL
406407
### Permissions
407408
INSERT permission is required on the target table.
408409

409-
INSERT permissions default to members of the **sysadmin** fixed server role, the **db_owner** and **db_datawriter** fixed database roles, and the table owner. Members of the **sysadmin**, **db_owner**, and the **db_securityadmin** roles, and the table owner can transfer permissions to other users.
410+
INSERT permissions default to members of the `sysadmin` fixed server role, the `db_owner` and `db_datawriter` fixed database roles, and the table owner. Members of the `sysadmin`, `db_owner`, and the `db_securityadmin` roles, and the table owner can transfer permissions to other users.
410411

411-
To execute INSERT with the OPENROWSET function BULK option, you must be a member of the **sysadmin** fixed server role or of the **bulkadmin** fixed server role.
412+
To execute INSERT with the OPENROWSET function BULK option, you must be a member of the `sysadmin` fixed server role or of the `bulkadmin` fixed server role.
412413

413414
## <a name="InsertExamples"></a> Examples
414415

0 commit comments

Comments
 (0)