Use bulk insert to import large batches of data to SQLSERVER

The following is an example:
Copy codeThe Code is as follows:
Create table [dbo]. [course] (
[Id] [int] NULL,
[Name] [nvarchar] (50) NULL,
[CourseType] [nvarchar] (50) NULL,
[Course] [float] NULL
)

Import data:
Store the following data as a text or SQL File
2, Li Gang, Chinese, 89; 3, Li Gang, mathematics, 79; 3, Li Gang, English, 69; 4, Li Gang, chemistry, 89
Import Statement:
Copy codeThe Code is as follows:
Bulk insert dbo. course
FROM 'd: \ course.txt'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = ';'
)

For bulk insert examples, see:

• Bulk insert (Transact-SQL)

• Examples of large-capacity Import and Export of XML documents

• Copy data between different sorting rules

• Mark value retained during data import in Large Capacity

• Retain Null values or use default values during mass import

• Field Terminator and line terminator

• Use a formatted file to import large data volumes

• Import or export data using character formats

• Import or export data in local format

• Use Unicode character format to import or export data

• Use Unicode local format to import or export data

• Skip table columns using formatted files

• Map a table column to a data file field using a formatted File