🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

����SQL server 2000�������..

#618
From: ����
Date: Wed, 26 Nov 2008 06:11
38 lines
2047 bytes
����ݿ�Ĵ洢��� A �е���������������洢��� B, C. �ȵ��� B , Ȼ����� C 
.

�м������⣺

1. ����B�ɹ�������C �����쳣����ô B��ִ�е������Ƿ�ᱣ�棿

2. B�ɹ���C�쳣�� �Ƿ������A�쳣��

3. ���C�м������ж��Ƿ��쳣�Ĵ��룬�ɹ�����0,�쳣����1����ôC���쳣�Ƿ����
��A�쳣��

4. ���A�ڵ���C��������ж��Ƿ��쳣�Ĵ��룺

   exec C

   if @@ErrorCode<>0

   Begin

   ...

   ...

   end

   ��ô exec C �������Щ���뻹�᲻��ִ�У�

5. �洢��̿��Եݹ������ ������A�е���A, ����B�е���C��ͬʱC�е���B ?

��дһ���洢��̣���֪������ô���ԣ����Ծ�����һ����Ҫ����ļ������⡣



--
�����ĵ�ץ���Ƕ���Ƥ��,������ˮ; ��ȴֻ�ܽ�����վ������,�����޴�...

�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 202.120.36.189]
Technical Details
Message-ID: <4dCkaQ$c8g@bbs.sjtu.edu.cn>
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!feeder.erje.net!newsfeed.straub-nv.de!news.mb-net.net!open-news-network.org!news.isoc.lu!news.shec6.edu.cn!SJTU

Show Full Headers
Complete Article Headers
X-Google-Thread: 101948,2d374dfa7c8f71a8,start
X-Google-Attributes: gid101948,domainid0,public,usenet
X-Google-Language: Chinese,GB
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!feeder.erje.net!newsfeed.straub-nv.de!news.mb-net.net!open-news-network.org!news.isoc.lu!news.shec6.edu.cn!SJTU
From: firbird.bbs@bbs.sjtu.edu.cn (����)
Newsgroups: cn.bbs.comp.database
Subject: ����SQL server 2000�������..
Date: 26 Nov 2008 06:11:48 GMT
Organization: ��ˮ˼Դ
Message-ID: <4dCkaQ$c8g@bbs.sjtu.edu.cn>
Mime-Version: 1.0
Content-Type: text/plain; charset="gb2312"
Content-Transfer-Encoding: 8bit
X-Filename: database/M.1227678938.A