🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: cn.bbs.comp.database
Article #49

Re: ���¸�λ��MS SQL�ܲ�������ô��

#49
From: Galaxy��VOLUNTEERS��Database
Date: Mon, 16 Nov 2009 11:47
21 lines
2060 bytes
�����SQL Server2008�Ļ��dz����㣬�б��������
http://www.sqlservercentral.com/articles/News/3182/
�����SQL Server 2005��һ������ķ�������ת��ΪXML string��Ȼ�󴫵ݸ�洢���
������Bulk insert���μ�
http://weblogs.asp.net/jgalloway/archive/2007/02/16/passing-lists-to-sql-serv
er-2005-with-xml-parameters.aspx

�� �� CFree (CFree) �Ĵ������ᵽ: ��
: ������ģ��ҵij���������һ������a��1000������ֱ����insertû���ȥ��������һ��
: ����SQL�����ʵ������ôʵ�ְ�����������1000��insert������Ч��̫���ˣ�
: �� �� ZAKU �Ĵ������ᵽ: ��
: : �����dz���ĸ���,������ݿ�ĸ���
: : ���ȸ������Ҫ����ʵ�ֻ���SQL���ʵ��


--
Welcome to Database Board
��ӭ������ݿ��
http://bbs.sjtu.edu.cn/bbsdoc?board=database

�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 207.46.55.31]
Technical Details
Message-ID: <4j2OEU$bee@bbs.sjtu.edu.cn>
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!feeder1.cambriumusenet.nl!feed.tweaknews.nl!194.109.133.84.MISMATCH!newsfeed.xs4all.nl!newsfeed5.news.xs4all.nl!xs4all!feeds.phibee-telecom.net!news.byr.edu.cn!news.shec6.edu.cn!SJTU

Show Full Headers
Complete Article Headers
X-Google-Thread: 4df683fd51,e246e7f38807597f,start
X-Google-Attributes: gid4df683fd51,public,usenet
X-Google-NewGroupId: yes
X-Google-Language: Chinese,GB
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!feeder1.cambriumusenet.nl!feed.tweaknews.nl!194.109.133.84.MISMATCH!newsfeed.xs4all.nl!newsfeed5.news.xs4all.nl!xs4all!feeds.phibee-telecom.net!news.byr.edu.cn!news.shec6.edu.cn!SJTU
From: Dem.bbs@bbs.sjtu.edu.cn (Galaxy��VOLUNTEERS��Database)
Newsgroups: cn.bbs.comp.database
Subject: Re: ���¸�λ��MS SQL�ܲ�������ô��
Date: 16 Nov 2009 11:47:40 GMT
Organization: ��ˮ˼Դ
Message-ID: <4j2OEU$bee@bbs.sjtu.edu.cn>
Mime-Version: 1.0
Content-Type: text/plain; charset="gb2312"
Content-Transfer-Encoding: 8bit
X-Filename: database/M.1258371774.A