> For the complete documentation index, see [llms.txt](https://jen-hsuan-hsieh.gitbook.io/database/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://jen-hsuan-hsieh.gitbook.io/database/chapter3-sql-server/32bcp.md).

# 3.2.BCP

## 1. Introduction

* The bulk copy (bcp) command of Microsoft SQL Server provides you with the ability to insert large numbers of records directly from the command line.

## 2.common use parameters

* -S
* -U
* -P
* -T

## 3.bcp import

<http://hoolihome.blogspot.tw/2016/07/bcp-uft-8.html>