Create Table statement

create table ge_historical_weather(
PBKEY CHAR (12),
HAIL_H5_COUNT INTEGER,
HAIL_H5GE_RANGE CHAR (25),
HAIL_RISKLEVEL CHAR (25),
TORNADO_F2_COUNT INTEGER,
TORNADO_F2GE_RANGE CHAR (25),
TORNADO_RISKLEVEL CHAR (25),
HURRICANE_COUNT INTEGER,
HURRICANE_EVENTS CHAR (25),
WIND_W9_COUNT INTEGER,
WIND_W9GE_RANGE CHAR (25),
WIND_RISKLEVEL CHAR (25)
)
------------------------------------------------------------------
Bulk insert command

BULK INSERT historical_weather
FROM 'E:\Abhishek\getting_started_guide\HistoricalWeatherRisk_C_TXT202012\historical_weather_risk_final_output.txt'
WITH
(
FIRSTROW = 2,
FIELDTERMINATOR = '|',
ROWTERMINATOR = '0x0a'
)
GO