Article View: cn.bbs.comp.database
Article #457Re: ��æ��һ�£�bcp�����⣿����
From: Galaxy��VOLUNTEERS��Database
Date: Wed, 01 Apr 2009 06:06
Date: Wed, 01 Apr 2009 06:06
22 lines
1692 bytes
1692 bytes
���ƺ����ע����ֵ�йذ�: HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Jet\4.0\Engines\Excel\First RowHasNames �� �� anycom (СC��) �Ĵ������ᵽ: �� : ���Ȼ�ѵ�һ�к����ˡ�����������˵���ӵ�һ�е���ݣ��ӵڶ��п�ʼ���롣 : bcp autoinfo.auto.y_address_temp in c:\Areatemp.cvs -F 2 -c -t , -r \n -S 127 : .0.0.1,1433 -U auto -P 123456 : �? : if exists (select * from dbo.sysobjects where id = object_id(N'[auto].[y_addre : ss_temp]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) : drop table [auto].[y_address_temp] : GO : CREATE TABLE [auto].[y_address_temp] ( : [ʡ] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL , : .................������ʡ�ԣ� -- Welcome to Database Board ��ӭ������ݿ�� http://bbs.sjtu.edu.cn/bbsdoc?board=database [m[1;33m�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 207.46.55.30][m
Technical Details
Message-ID:
<4fFK12$byh@bbs.sjtu.edu.cn>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!newshub.sdsu.edu!newsgate.cuhk.edu.hk!news.neu.edu.cn!news.shec6.edu.cn!SJTUShow Full Headers
Complete Article Headers
X-Google-Thread: 101948,990385e896cb496f,start X-Google-Attributes: gid101948,domainid0,public,usenet X-Google-Language: Chinese,GB Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!newshub.sdsu.edu!newsgate.cuhk.edu.hk!news.neu.edu.cn!news.shec6.edu.cn!SJTU From: Dem.bbs@bbs.sjtu.edu.cn (Galaxy��VOLUNTEERS��Database) Newsgroups: cn.bbs.comp.database Subject: Re: ��æ��һ�£�bcp�����⣿���� Date: 01 Apr 2009 06:06:03 GMT Organization: ��ˮ˼Դ Message-ID: <4fFK12$byh@bbs.sjtu.edu.cn> Mime-Version: 1.0 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: 8bit X-Filename: database/M.1238565938.A