Create Table statement

create table ge_earthquake(
PBKEY CHAR (12),
EQ_R0 INTEGER,
EQ_R1 INTEGER,
EQ_R2 INTEGER,
EQ_R3 INTEGER,
EQ_R4 INTEGER,
EQ_R5 INTEGER,
EQ_R6 INTEGER,
EQ_R7 INTEGER,
EQ_R0_GE INTEGER,
EQ_R1_GE INTEGER,
EQ_R2_GE INTEGER,
EQ_R3_GE INTEGER,
EQ_R4_GE INTEGER,
EQ_R5_GE INTEGER,
EQ_R6_GE INTEGER,
EQ_R7_GE INTEGER,
EQF_NAME CHAR (80),
EQF_DIST DECIMAL (20, 5),
EQF_SLIPRT CHAR (15),
EQF_TYPE CHAR (25),
EQF_SLDRCD VARCHAR (15),
EQF_AGE CHAR (30),
EQF_SLPSNS CHAR (15),
EQF_DIPDIR CHAR (15),
PML_ZONEGRADE VARCHAR (2),
EQS_NEHRP VARCHAR (2),
EQS_INDEX DECIMAL (20,5),
NEWMADRID_DIST DECIMAL (20,5)
)
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Bulk inset command

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