toc.yml

- name: Bulk Import and Export of Data
  href: bulk-import-and-export-of-data-sql-server.md
  items:
  - name: Import and Export Bulk Data by Using the bcp Utility
    href: import-and-export-bulk-data-by-using-the-bcp-utility-sql-server.md
  - name: Import Bulk Data by Using BULK INSERT or OPENROWSET(BULK...)
    href: import-bulk-data-by-using-bulk-insert-or-openrowset-bulk-sql-server.md
  - name: Prerequisites for Minimal Logging in Bulk Import
    href: prerequisites-for-minimal-logging-in-bulk-import.md
- name: Prepare to Bulk Import Data
  href: prepare-to-bulk-import-data-sql-server.md
  items:
  - name: Prepare Data for Bulk Export or Import
    href: prepare-data-for-bulk-export-or-import-sql-server.md
- name: HumanResources.myTeam Sample Table
  href: humanresources-myteam-sample-table-sql-server.md
- name: Data Formats for Bulk Import or Bulk Export
  href: data-formats-for-bulk-import-or-bulk-export-sql-server.md
  items:
  - name: Use Native Format to Import or Export Data
    href: use-native-format-to-import-or-export-data-sql-server.md
  - name: Use Character Format to Import or Export Data
    href: use-character-format-to-import-or-export-data-sql-server.md
  - name: Use Unicode Native Format to Import or Export Data
    href: use-unicode-native-format-to-import-or-export-data-sql-server.md
  - name: Use Unicode Character Format to Import or Export Data
    href: use-unicode-character-format-to-import-or-export-data-sql-server.md
  - name: Import Native and Character Format Data from Earlier Versions of SQL Server
    href: import-native-and-character-format-data-from-earlier-versions-of-sql-server.md
- name: Specify Data Formats for Compatibility when Using bcp
  href: specify-data-formats-for-compatibility-when-using-bcp-sql-server.md
  items:
  - name: Specify File Storage Type by Using bcp
    href: specify-file-storage-type-by-using-bcp-sql-server.md
  - name: Specify Prefix Length in Data Files by Using bcp
    href: specify-prefix-length-in-data-files-by-using-bcp-sql-server.md
  - name: Specify Field Length by Using bcp
    href: specify-field-length-by-using-bcp-sql-server.md
  - name: Specify Field and Row Terminators
    href: specify-field-and-row-terminators-sql-server.md
- name: Keep Nulls or Use Default Values During Bulk Import
  href: keep-nulls-or-use-default-values-during-bulk-import-sql-server.md
- name: Keep Identity Values When Bulk Importing Data
  href: keep-identity-values-when-bulk-importing-data-sql-server.md
- name: Bulk Import Large-Object Data by using the OPENROWSET Bulk Rowset Provider
  href: bulk-import-large-object-data-with-openrowset-bulk-rowset-provider.md
- name: Format Files for Importing or Exporting Data
  href: format-files-for-importing-or-exporting-data-sql-server.md
  items:
  - name: Non-XML Format Files
    href: non-xml-format-files-sql-server.md
  - name: XML Format Files
    href: xml-format-files-sql-server.md
  - name: Create a Format File
    href: create-a-format-file-sql-server.md
  - name: Use a Format File to Bulk Import Data
    href: use-a-format-file-to-bulk-import-data-sql-server.md
  - name: Use a Format File to Skip a Table Column
    href: use-a-format-file-to-skip-a-table-column-sql-server.md
  - name: Use a Format File to Skip a Data Field
    href: use-a-format-file-to-skip-a-data-field-sql-server.md
  - name: Use a Format File to Map Table Columns to Data-File Fields
    href: use-a-format-file-to-map-table-columns-to-data-file-fields-sql-server.md
- name: Examples of Bulk Import and Export of XML Documents
  href: examples-of-bulk-import-and-export-of-xml-documents-sql-server.md