Create table statement

create table ge_property_fire_protection(
PBKEY CHAR (12),
place_code CHAR (12),
place_name character varying(50),
fs1_department_id INTEGER,
fs1_department_type character varying(20),
fs1_station_id INTEGER,
fs1_drivetime_ampeak decimal(20,5),
fs1_drivetime_pmpeak decimal(20,5),
fs1_drivetime_offpeak decimal(20,5),
fs1_drivetime_night decimal(20,5),
fs1_drivedistance decimal(20,5),
fs2_department_id INTEGER,
fs2_department_type character varying(20),
fs2_station_id INTEGER,
fs2_drivetime_ampeak decimal(20,5),
fs2_drivetime_pmpeak decimal(20,5),
fs2_drivetime_offpeak decimal(20,5),
fs2_drivetime_night decimal(20,5),
fs2_drivedistance decimal(20,5),
fs3_department_id INTEGER,
fs3_department_type character varying(20),
fs3_station_id INTEGER,
fs3_drivetime_ampeak decimal(20,5),
fs3_drivetime_pmpeak decimal(20,5),
fs3_drivetime_offpeak decimal(20,5),
fs3_drivetime_night decimal(20,5),
fs3_drivedistance decimal(20,5),
nearest_water_body decimal(20,5)
)
------------------------------------------------------------------------
Bulk insert command

BULK INSERT <Table name>
FROM '<Path of data file>'
WITH
(
FIRSTROW = 2,
FIELDTERMINATOR = '|',
ROWTERMINATOR = '0x0a'
)
GO