BULK INSERT

BULK INSERT TEST_TABLE

FROM ‘Test_data.txt’

WITH

(

FIELDTERMINATOR =’,',

ROWTERMINATOR = ‘\n’

)

Bulk Insert is a method of inserting Text data or Row data in to Sql table directly.

For inserting that we need to specify the Destination table(Here TEST_TABLE)

Source data(Here Test_data.txt), FIELDTERMINATOR(For inserting to each particular element to respective columns) and

ROWTERMINATOR(For terminating each Row).

BULK INSERT

BULK INSERT TEST_TABLE

FROM ‘Test_data.txt’

WITH

(

FIELDTERMINATOR =’,',

ROWTERMINATOR = ‘\n’

)

Bulk Insert is a method of inserting Text data or Raw data in to Sql table directly.

For inserting that we need to specify the Destination table(Here TEST_TABLE)

Source data(Here Test_data.txt), FIELDTERMINATOR(For inserting to each particular element to respective columns) and

ROWTERMINATOR(For terminating each Row).

Advertisement