Re: ��̴��

Article View: cn.bbs.comp.database

Article #9903

Back to cn.bbs.comp.database Previous Next

#9903

From: ��·
Date: Wed, 29 Jul 1998 00:00

23 lines
1198 bytes

CREATE TRIGGER intrig
ON sales
FOR INSERT AS
IF @@rowcount=1
        UPDATE titles
        SET ytd_sales=ytd_sales+qty
        FROM INSERTED
        WHERE titles.title_id=indweted.title_id
ELSE
        UPDATE titles
        SET ytd_sales=ytd_sales+(select sum(qty)
                FROM inserted
                GROUP BYinseted.title_id
                HAVING titles.title_id=inserted.title_id)

�� �� xyd.bbs@bbs.nease.net (xyd) �Ĵ������ᵽ: ��
: ������SQL SERVER 6.5����α�д���Ʊ�֤head-detail
: �����һ���Ե�ɾ�������������һ�����ӡ�
: �ǳ���л!


--
[m[1;35m�� ��Դ:������������BBS bbs.huizhou.gd.cn��[FROM: 202.102.2.109][m

Technical Details

Message-ID: <3Pf8Hi$Wyz@bbs.hz.gnet.gd.cn>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII
X-Google-Thread: 101948,3dc38f5ef6ef6b62,start
X-Google-Attributes: gid101948,public
From: bjg.bbs@bbs.hz.gnet.gd.cn (��·)
Subject: Re: ��̴�����
Date: 1998/07/29
Message-ID: <3Pf8Hi$Wyz@bbs.hz.gnet.gd.cn>
X-Deja-AN: 375855581
Organization: HuiZhou BBS
X-Filename: Database/M.901675868.A
Newsgroups: cn.bbs.comp.database

Article View: cn.bbs.comp.database

Re: ��̴�����

Re: ��̴��