表结构如下:
CREATE TABLE [dbo].[ShopInfo](
[Id] [int] IDENTITY(0,1) NOT NULL,
[Type] [int] NOT NULL,
[Name] [varchar](60) NOT NULL,
[Address] [varchar](60) NOT NULL,
[Region] [int] NOT NULL,
[SubType] [int] NOT NULL CONSTRAINT [DF_ShopInfo_SubType] DEFAULT ((1)),
[SubRegion] [int] NULL,
[Description] [varchar](500) NULL,
[Phone] [varchar](40) NULL,
[WebSite] [varchar](30) NULL,
[Time] [varchar](50) NULL,
[Bus] [varchar](50) NULL,
[Neighbor] [varchar](80) NULL,
[ConsumeObject] [varchar](80) NULL,
[AverageCost] [varchar](80) NULL,
[Image] [varchar](40) NOT NULL CONSTRAINT [DF_ShopInfo_Image] DEFAULT ('/ShopPhoto/NoPhoto.GIF'),
[CreateTime] [datetime] NOT NULL,
[ClickTimes] [int] NOT NULL CONSTRAINT [DF_ShopInfo_ClickTimes] DEFAULT ((0)),
[UserId] [int] NULL,
[ShopClass] [int] NOT NULL CONSTRAINT [DF_ShopInfo_IsMember] DEFAULT ((0))
}txt 文件如下:
type Name Address Region SubType Description
8 东方新娘婚纱摄影 广州市越秀区越秀北路448号 6 16
6 金夫人婚纱艺术摄影有限公司 沿江西路11号 4 18 本着一切为顾客.. 文件里面有些字段是空的 ,, 导入时怎么知道哪个字段对应哪个. 上面 要写一行字段名吗?BULK INSERT dbo.ShopInfo
FROM 'H:\Shop.txt'
WITH (
FIELDTERMINATOR = ' ', (空格是怎么写的呢?)
ROWTERMINATOR = '\n'
)怎样用 BULK INSERT 导入了???? 新手求助!!!!!
CREATE TABLE [dbo].[ShopInfo](
[Id] [int] IDENTITY(0,1) NOT NULL,
[Type] [int] NOT NULL,
[Name] [varchar](60) NOT NULL,
[Address] [varchar](60) NOT NULL,
[Region] [int] NOT NULL,
[SubType] [int] NOT NULL CONSTRAINT [DF_ShopInfo_SubType] DEFAULT ((1)),
[SubRegion] [int] NULL,
[Description] [varchar](500) NULL,
[Phone] [varchar](40) NULL,
[WebSite] [varchar](30) NULL,
[Time] [varchar](50) NULL,
[Bus] [varchar](50) NULL,
[Neighbor] [varchar](80) NULL,
[ConsumeObject] [varchar](80) NULL,
[AverageCost] [varchar](80) NULL,
[Image] [varchar](40) NOT NULL CONSTRAINT [DF_ShopInfo_Image] DEFAULT ('/ShopPhoto/NoPhoto.GIF'),
[CreateTime] [datetime] NOT NULL,
[ClickTimes] [int] NOT NULL CONSTRAINT [DF_ShopInfo_ClickTimes] DEFAULT ((0)),
[UserId] [int] NULL,
[ShopClass] [int] NOT NULL CONSTRAINT [DF_ShopInfo_IsMember] DEFAULT ((0))
}txt 文件如下:
type Name Address Region SubType Description
8 东方新娘婚纱摄影 广州市越秀区越秀北路448号 6 16
6 金夫人婚纱艺术摄影有限公司 沿江西路11号 4 18 本着一切为顾客.. 文件里面有些字段是空的 ,, 导入时怎么知道哪个字段对应哪个. 上面 要写一行字段名吗?BULK INSERT dbo.ShopInfo
FROM 'H:\Shop.txt'
WITH (
FIELDTERMINATOR = ' ', (空格是怎么写的呢?)
ROWTERMINATOR = '\n'
)怎样用 BULK INSERT 导入了???? 新手求助!!!!!
希望大家 教教小弟!!!