看了一下文件结构,用“ # ”分隔,貌似SQL Server就能搞定:
CREATE TABLE [dbo].[CSDNEmail](
[UserName] [nvarchar]
(
50
)
NULL,
[Password] [nvarchar]
(
50
)
NULL,
[Email] [nvarchar]
(
100
)
NULL
)
ON
[PRIMARY]
GO
BULK
INSERT
dbo
.
CSDNEmail
FROM
'E:\csdn.net.email.sql'
WITH
(
FIELDTERMINATOR
=
' # '
,
ROWTERMINATOR
=
'\n'
)
【脚本仅供参考,没有测试过】