Re: ��µĴ��ôд~~~

Article View: cn.bbs.comp.database

Article #8560

Back to cn.bbs.comp.database Previous Next

#8560

From: ��
Date: Thu, 13 Nov 2003 09:03

22 lines
1611 bytes

  begin

  update worker set worker.departID = :new.deprtID where
    worker.departID = :old.departID;
  ......--others three
  end;

�� �� kitmik (������) �Ĵ������ᵽ: ��
: ��Ҫʵ��,һ���������µĴ�����
: �����ű�.depart.worker.salary.job.
: ���涼��departID����ֶ�~~
: ��д����ʵ��,���Ҹ���depart���е�ĳһ��departID�ֶ�ʱ,��Ӧ���ĸ����е���Ӧ�ֶ�
: .ͬʱҲ���.
: create trigger departID_update
:            on depart for update
: as 
:             ����Ӧ����ôд��??
: ��Ұ���һ��.лл��~~~~~~~~~
: ...........................

--
[m[1;33m�� ��Դ:������δ��վ bbs.pku.edu.cn��[FROM: 61.149.132.177][m

Technical Details

Message-ID: <49FRPV$ZW2@bbs.pku.edu.cn>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed.media.kyoto-u.ac.jp!newsgate.cuhk.edu.hk!news.zixia.net!news.happynet.org!PKU

Show Full Headers

Complete Article Headers

X-Google-Language: Chinese,GB
X-Google-Thread: 101948,6978f06cad2c5274,start
X-Google-Attributes: gid101948,public
X-Google-ArrivalTime: 2003-11-13 01:04:09 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed.media.kyoto-u.ac.jp!newsgate.cuhk.edu.hk!news.zixia.net!news.happynet.org!PKU
From: maghaen@bbs.pku.edu.cn (�������)
Newsgroups: cn.bbs.comp.database
Subject: Re: �������µĴ�������ôд~~~
Date: 13 Nov 2003 09:03:12 GMT
Organization: ����δ��վ
Message-ID: <49FRPV$ZW2@bbs.pku.edu.cn>
Mime-Version: 1.0
Content-Type: text/plain; charset="gb2312"
Content-Transfer-Encoding: 8bit
X-Filename: Database/M.1068713935.A
Lines: 22

Article View: cn.bbs.comp.database

Re: �������µĴ�������ôд~~~

Re: ��µĴ��ôд~~~