Bulk insert in mssqlserver batch import data SQL SERVER

The following is an example:

The code is as follows:	Copy code
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:

The code is as follows:	Copy code
Bulk insert dbo. course FROM 'd: course.txt' WITH (  FIELDTERMINATOR = ',', ROWTERMINATOR = ';' )