SQL Server/T-SQL/Insert Delete Update/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