insert data

Question

Q:- How can insert one million data in one time in single table?

Rohit Mane · Answer

BULK INSERT The first statement we’ll look at is BULK INSERT which lets you import data from a data file into a table or view. You can specify the format of the imported data based on how that data is stored in the file. In the following example I import the data from the EmployeeData_c.dat file into the Employees table: BULK INSERT EmployeeDB . dbo . Employees FROM 'C:\Data\EmployeeData_c.dat' WITH ( DATAFILETYPE = 'char'  FIELDTERMINATOR = ''  ROWTERMINATOR = '
' );