假如有一张表,其脚本如下:
CREATE TABLE [dbo].[KOP_Stones](
[StoneIdx] [int] NOT NULL,
[StoneName] [nvarchar](50) NOT NULL,
[StoneNo] [int] NOT NULL,
[StoneLevel] [nvarchar](50) NOT NULL,
[StoneType] [int] NOT NULL,
CONSTRAINT [PK_StoneInfo] PRIMARY KEY CLUSTERED
(
[StoneIdx] ASC
) ON [PRIMARY]
) ON [PRIMARY]
GO
现在要将一个Stone.txt里的数据导入到该表中,改Stone.txt(D:/KopLog/InitData/Stone.txt)里的数据如下:
1|烈炎石|0878|1|1
2|炙焰石|0879|2,3,7,9|1
3|火药石|0880|4|1
4|玛瑙石|0881|1,2,3,4,7,9,23|1
5|寒玉|0882|11,22,27|2
6|月之心|0883|11,22,27|2
7|仙灵石|0884|1,2,3,4,7,9,24|2
8|圣光石|0887|1,2,3,4,7,9,24|4
9|风灵石|0860|24|4
10|鹰眼石|0861|23|4
11|岩玉|0862|11,22,27|4
12|炎玉|0863|1,2,3,4,7,9|4
13|黑龙之瞳|0864|1,2,3,4,7,9|1
14|黑龙之魂|0865|11,22,27|2
15|黑龙之心|0866|23,24|2
16|加纳之神|1012|1,2,3,4,7,9|4
17|黄玉|5750|20|