/*c:\produs.txt
1,pix
2,carneţel
3,corcoduşe
4,ursuleţi
5,imprimantă
*/
CREATE TABLE tblProdus
(
Cod INT PRIMARY KEY,
Denumire NVARCHAR(25) NOT NULL
)
GO
BULK INSERT tblProdus
FROM 'c:\produs.txt'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n',
DATAFILETYPE = 'widechar'
)
GO
/*
(5 row(s) affected)
*/
SELECT *
FROM tblProdus
GO