ALTER PROCEDURE HA_MAJ_REXEL
@CSV_PATH VARCHAR(200)
AS
IF EXISTS (SELECT name FROM sysobjects WHERE name = '#TmpStList')
DROP TABLE #TmpStList
IF EXISTS (SELECT name FROM sysobjects WHERE name = 'StudentList')
DROP TABLE StudentList
CREATE TABLE dbo.StudentList
( FName int,
LName int )
CREATE TABLE TmpStList
( stFName int, stLName int
)
/* partie ou j'indique le chemin
--BULK INSERT #TmpStList FROM 'E:\Fichier_test.csv' WITH (FIELDTERMINATOR = ';')
/* ici ça ne marche pas j'ai tester avec '@mavariable', compilation ça marche mais execution non idem lorsque je mets "" */
BULK INSERT #TmpStList FROM @CSV_PATH WITH (FIELDTERMINATOR = ';')
--print 'le chemin = '+ CONVERT(VARCHAR(100),@CSV_PATH)
INSERT StudentList (FName,LName)
SELECT stFName, stLName + stLName
FROM #TmpStList
DROP TABLE #TmpStList
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
Partager