Скачать или смотреть How to import Data into a SQL Server by using bulk Copy SQL Query | SQL Bulk Copy

In this sql tutorial, we are going to learn how to use SQL BULK INSERT statement to import text file into Microsoft sql server database.
Instead of manually Text file using Import Data File wizard, we can easily write a T-SQL statement to do that. BULK INSERT loads data from a data file into a table. SQL Server has a great function called bulk insert that will allow us to load data in different delimited format. This could be CSV, TSV, Pipe-delimited, etc. This functionality in SQL Server is very handy when you need to load data automatically. It can be used to create automated systems.

--Example
Bulk Insert TestDB.dbo.tblEmployee
from 'C:\SQlData\EmpData.txt'
with (
Fieldterminator =',',
Rowterminator=';\n'
)
Go

#sql #sqlserver #SQLServer #BULKINSERT #TSQL #sqlquery #sqlqueries #sqltutorial #sqltutorialforbeginners #sqltutorials