/*    ==Scripting Parameters==

    Source Server Version : SQL Server 2016 (13.0.4001)
    Source Database Engine Edition : Microsoft SQL Server Enterprise Edition
    Source Database Engine Type : Standalone SQL Server

    Target Server Version : SQL Server 2017
    Target Database Engine Edition : Microsoft SQL Server Standard Edition
    Target Database Engine Type : Standalone SQL Server
*/

USE [AjoneuvojenAvoinData]
GO
/****** Object:  StoredProcedure [dbo].[TESTI1]    Script Date: 24.10.2017 12.19.50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		Name
-- Create date:
-- Description:
-- =============================================
ALTER PROCEDURE [dbo].[TESTI1]

AS
BEGIN

	SET NOCOUNT ON;

BULK INSERT dbo.AjoneuvoDATA
FROM 'C:\Users\Aapo\Downloads\AvoinData\TieliikenneAvoinData.csv'
WITH(FIELDTERMINATOR =';',
	ROWTERMINATOR = '\n')
	END