參考樣式:
USE master
CREATE DATABASE Accounting
GO
CREATE TABLE Accounting.dbo.Customer (
CustomerID nchar (5) NOT NULL ,
CompanyName nvarchar (40) NOT NULL ,
ContactName nvarchar (30) NULL ,
ContactTitle nvarchar (30) NULL ,
Address nvarchar (60) NULL ,
City nvarchar (15) NULL ,
Region nvarchar (15) NULL ,
PostalCode nvarchar (10) NULL ,
Country nvarchar (15) NULL ,
Phone nvarchar (24) NULL ,
Fax nvarchar (24) NULL )
GO
BULK INSERT Accounting.dbo.Customer
FROM 'C:SelfPacedSQLCH_9NewCustomerData1.txt'
WITH
(
DATAFILETYPE = 'char' ,
FIELDTERMINATOR = ',',
ROWTERMINATOR = 'n' )
聯(lián)系客服