IncludeIdentityValues Property
The IncludeIdentityValues property controls the handling of existing values for a column with the Microsoft® SQL Server™ identity property when data is copied to the SQL Server table.
Applies To
BulkCopy Object |
Syntax
object.IncludeIdentityValues [= value]
Parts
object
Expression that evaluates to an object in the Applies To list
value
TRUE or FALSE
Data Type
Boolean
Modifiable
Read/write
Prototype (C/C++)
HRESULT GetIncludeIdentityValues(LPBOOL pRetVal);
HRESULT SetIncludeIdentityValues(BOOL NewValue);
Remarks
When TRUE, SQL-DMO executes a SET IDENTITY_INSERT ON statement when the ImportData method of a Table object is called.
When FALSE, SQL-DMO ignores any data values present for a column with the identity property. SQL Server generates data values for the column by using the column's setting for identity seed and increment. The default is FALSE.