🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: sql�е�һ������

#408
From: Galaxy��VOLUNTEERS��Database
Date: Tue, 28 Apr 2009 06:32
24 lines
2223 bytes
�������ÿ�����?��Ĵ�����Ļ����Է��������Ҫ����SQL Server 
Integration Services�Ļ���Foreach Loop Container����������Ķ���󡣡���
ֱ�Ӳ����滻Ҳͦ����ô��

��˵���Կ�serverִ�С�������
 �� �� zichuan (����) �Ĵ������ᵽ: ��
: д�˶δ��룬����κܳ�����������С�
: ���ڴ��������������ѭ������ѭ�����£���ʵ����ÿ����ѭ���󣬰������dbo.test1��
: �Ƴ�[ServerName].[Database].dbo.test1���������е�ServerName��Database���Ǵ���ѭ
: ������ġ���������ȥֻ��һ���취�������д��������stringȻ��execִ�У����ʻ���
: ����ĺ÷����𣿱Ͼ�������д���ȫ������ȥ�øĺܶ�ط�
: ����������������������������������������������������������
: declare @id int
: declare cur cursor for
: select id from dbo.test1
: order by id
: .................������ʡ�ԣ�

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

�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 219.142.46.134]
Technical Details
Message-ID: <4faP7I$aib@bbs.sjtu.edu.cn>
Path: arc1-ca.pugleaf.net!g2news2.google.com!news2.google.com!npeer02.iad.highwinds-media.com!news.highwinds-media.com!feed-me.highwinds-media.com!news.glorb.com!feeder.erje.net!news.byr.edu.cn!news.shec6.edu.cn!SJTU

Show Full Headers
Complete Article Headers
X-Google-Language: Chinese,GB
Path: arc1-ca.pugleaf.net!g2news2.google.com!news2.google.com!npeer02.iad.highwinds-media.com!news.highwinds-media.com!feed-me.highwinds-media.com!news.glorb.com!feeder.erje.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: sql�е�һ������
Date: 28 Apr 2009 06:32:42 GMT
Organization: ��ˮ˼Դ
Message-ID: <4faP7I$aib@bbs.sjtu.edu.cn>
Mime-Version: 1.0
Content-Type: text/plain; charset="gb2312"
Content-Transfer-Encoding: 8bit
X-Filename: database/M.1240900194.A