BULK INSERT dbo.mybcp : BULK INSERT « Insert Delete Update « SQL Server / T-SQL

1. SQL Server / T-SQL
2. Insert Delete Update
3. BULK INSERT

BULK INSERT dbo.mybcp

 


4> CREATE TABLE mybcp
5> (
6>     col1 char(3),
7>     col2 INT
8> )
9> GO
1>
2> BULK INSERT dbo.mybcp
3> FROM 'c:\mydata.txt'
4> WITH
5> (DATAFILETYPE = 'char',
6> FIELDTERMINATOR = ',', ROWTERMINATOR = ';')
7> GO
1>
2> drop table mybcp;
3> GO

 

Related examples in the same category