BULK INSERT — dynamic SQL

BULK INSERT [dbo].[GHCN]
FROM ‘D:\New\2020.csv’
WITH(
FIRSTROW = 2,
ROWTERMINATOR = ‘0x0a’,
FIELDTERMINATOR = ‘,’,
TABLOCK
)
EXEC master.sys.xp_dirtree @folder_path,0,1
WHILE EXISTS(
SELECT TOP 1 subdirectory
FROM #FilesList
WHERE isprocessed = 0
)

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store