Insert Delete Update MSSQL

  1. Home
  2. MSSQL
  3. Insert Delete Update
  4. 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