Untitled

 avatar
unknown
sql
a year ago
708 B
4
Indexable
	
	DROP TABLE IF EXISTS [SANDBOX_DB_TEAM_21].[dbo].[rosstat_idx_ipp]

	CREATE TABLE [SANDBOX_DB_TEAM_21].[dbo].[rosstat_idx_ipp]
	 (Регион [nvarchar](255) NULL,
	  Дата [nvarchar](255) NULL,
	  Значение [decimal](19,0) NULL)
	  	  
		  
	BULK INSERT [SANDBOX_DB_TEAM_21].[dbo].[-]
	FROM '\\spb99-fss01\DataLakeDRP_SandBox\TEAM_21\Антон_БКД\Data\to_datalake\rosstat_indexes\info-stat-11-2023\01 промышленность\01-01 индекс промышленного производства.csv' 
	WITH(
	FIRSTROW =2,
	ROWTERMINATOR='\n', 
	FIELDTERMINATOR=';', 
	FORMAT='csv',
	CODEPAGE='1251');

	Select * FROM [SANDBOX_DB_TEAM_21].[dbo].[rosstat_idx_ipp]

Editor is loading...
Leave a Comment