SQL Server/T-SQL/Insert Delete Update/BULK INSERT
BULK INSERT dbo.mybcp
<source lang="sql">
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
</source>