表的属性是这样子的:
CREATE TABLE [dbo].[distributors] (
[Distri_num] [int] primary key ,
[Boss_name] [char](16) COLLATE Chinese_PRC_CI_AS NULL ,
[Company] [char](20) COLLATE Chinese_PRC_CI_AS NULL ,
[Hsienshi_code] [char](4) COLLATE Chinese_PRC_CI_AS NULL ,
[Address] [char](30) COLLATE Chinese_PRC_CI_AS NULL ,
[Phone] [char](12) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[distributors] (
[Distri_num] [int] primary key ,
[Boss_name] [char](16) COLLATE Chinese_PRC_CI_AS NULL ,
[Company] [char](20) COLLATE Chinese_PRC_CI_AS NULL ,
[Hsienshi_code] [char](4) COLLATE Chinese_PRC_CI_AS NULL ,
[Address] [char](30) COLLATE Chinese_PRC_CI_AS NULL ,
[Phone] [char](12) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
解决方案 »
- sqlserver优化问题,急
- 关于distinct后面跟数字的问题
- sql server varchar 类型默认值 要求 convert(varchar,1000000000000+ID)+convert(varchar,getdate(),112)
- 外联接问题,急!!!!
- sql群号码6932214欢迎加入
- 求SQL,把几条记录中的某个字段组合成一个逗号分隔的字符串
- SQL Server 2005 for xml XX
- 在一个空数据库中新建的表和函数为什么也会出现排序规则的错误??
- 能否建立这样的约束?
- objconn.execute "update GR_bbs set [restore]=[restore]+'"&res&"' where cstr(ID) ='"&request("parentid")&"'"
- 这个日期函数该怎么写?
- 一个复杂的查询问题
1021,"江仁义 ","南阳实业 ","ILH ","富强路2段14号34楼 ","036549812 "
--把数据改一下:
1020,"陈信德","天河信息","TYH ","治平路2段97号","0225642319"
1021,"江仁义","南阳实业","ILH ","富强路2段14号34楼","036549812"--由于你的数据中有太多的空格,所以发生楼主所说的情况
/** 导入文本文件
EXEC master..xp_cmdshell 'bcp dbname..tablename in c:\DT.txt -c -Sservername -Usa -Ppassword'/** 导出文本文件
EXEC master..xp_cmdshell 'bcp dbname..tablename out c:\DT.txt -c -Sservername -Usa -Ppassword'
或
EXEC master..xp_cmdshell 'bcp "Select * from dbname..tablename" queryout c:\DT.txt -c -Sservername -Usa -Ppassword'导出到TXT文本,用逗号分开
exec master..xp_cmdshell 'bcp "库名..表名" out "d:\tt.txt" -c -t ,-U sa -P password'
1021,江仁义 ,南阳实业 ,ILH ,富强路2段14号34楼 ,036549812 导入时就没问题勒,请大侠告知,在字符串上加上""界定符时如何处理"",把他去掉呢?
用什么参数,谢谢!
1. Format file (Examples on Google)
2. Do a REPLACE() on the after post import.
详细可以参看:
http://www.microsoft.com/sql/community/newsgroups/dgbrowser/en-us/default.mspx?query=bulk%20insert&dg=&cat=&lang=en&cr=US&pt=&catlist=6C839803-6334-48D8-A2C3-72A1BEF0053D&dglist=&ptlist=~Microsoft%20SQL%20Server
揭帖