Tedious
    Preparing search index...

    Interface BulkLoadOptions

    interface BulkLoadOptions {
        checkConstraints?: boolean;
        fireTriggers?: boolean;
        keepNulls?: boolean;
        lockTable?: boolean;
        order?: { [columnName: string]: "ASC" | "DESC" };
    }
    Index

    Properties

    checkConstraints? fireTriggers? keepNulls? lockTable? order?

    Properties

    checkConstraints?: boolean

    Honors constraints during bulk load, using T-SQL CHECK_CONSTRAINTS. (default: false)

    fireTriggers?: boolean

    Honors insert triggers during bulk load, using the T-SQL FIRE_TRIGGERS. (default: false)

    keepNulls?: boolean

    Honors null value passed, ignores the default values set on table, using T-SQL KEEP_NULLS. (default: false)

    lockTable?: boolean

    Places a bulk update(BU) lock on table while performing bulk load, using T-SQL TABLOCK. (default: false)

    order?: { [columnName: string]: "ASC" | "DESC" }

    Specifies the ordering of the data to possibly increase bulk insert performance, using T-SQL ORDER. (default: {})

    Settings

    Member Visibility

    On This Page

    Properties