Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Trigger is fired every record or multiple records per update?

3 posts in Windows NT Last posting was on 1999-12-20 19:52:55.0Z
Leigh Wanstead Posted on 1999-12-19 19:52:57.0Z
From: "Leigh Wanstead" <leigh@wds.co.nz>
Subject: Trigger is fired every record or multiple records per update?
Date: Mon, 20 Dec 1999 08:52:57 +1300
Lines: 12
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Message-ID: <kygnYslS$GA.288@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: b001-m003-p013.acld.clear.net.nz 203.97.53.205
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2801
Article PK: 1090239

Hello everyone,

I just want to know is that trigger code fired every record or multiple
records per update. If it is fired multiple records per update, I have to
use cursor to browse the inserted table.

Thanks in advance.

Best Regards
Leigh Wanstead


Bret Halford Posted on 1999-12-19 22:52:36.0Z
Message-ID: <385D61B4.4F9C@sybase.com>
Date: Sun, 19 Dec 1999 15:52:36 -0700
From: Bret Halford <bret@sybase.com>
Organization: Customer Service & Support
X-Mailer: Mozilla 3.0 (X11; U; SunOS 5.5.1 sun4m)
MIME-Version: 1.0
To: Leigh Wanstead <leigh@wds.co.nz>
Subject: Re: Trigger is fired every record or multiple records per update?
References: <kygnYslS$GA.288@forums.sybase.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 15
NNTP-Posting-Host: 157.133.214.40
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2800
Article PK: 1090238


Leigh Wanstead wrote:
>
> Hello everyone,
>
> I just want to know is that trigger code fired every record or multiple
> records per update. If it is fired multiple records per update, I have to
> use cursor to browse the inserted table.
>

Update triggers are triggered once per update statement, not once for
every row. If multiple rows were modified by a single update statment,
then there will be multiple records in the inserted pseudotable.


--
Bret Halford
Sybase Technical Support
3665 Discovery Drive
Boulder, CO 80303


Leigh Wanstead Posted on 1999-12-20 19:52:55.0Z
From: "Leigh Wanstead" <leigh@wds.co.nz>
References: <kygnYslS$GA.288@forums.sybase.com> <385D61B4.4F9C@sybase.com>
Subject: Re: Trigger is fired every record or multiple records per update?
Date: Tue, 21 Dec 1999 08:52:55 +1300
Lines: 44
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Message-ID: <6oAaCRyS$GA.164@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: b002-m003-p002.acld.clear.net.nz 203.167.198.130
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2795
Article PK: 1090234

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Dear Bret Halford,

Thank you.
Merry Christmas and Happy New Year.

Best Regards
Leigh Wanstead

Bret Halford <bret@sybase.com> wrote in message
news:385D61B4.4F9C@sybase.com...
> Leigh Wanstead wrote:
> >
> > Hello everyone,
> >
> > I just want to know is that trigger code fired every record or
> > multiple records per update. If it is fired multiple records per
> > update, I have to use cursor to browse the inserted table.
> >
>
> Update triggers are triggered once per update statement, not once
> for every row. If multiple rows were modified by a single update
> statment, then there will be multiple records in the inserted
> pseudotable.
>
>
> --
> Bret Halford
> Sybase Technical Support
> 3665 Discovery Drive

Boulder, CO 80303

-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 6.5.1 for non-commercial use <http://www.pgp.com>

iQA/AwUBOF3gV+cpyPm4rG9PEQJH5QCggNW46aS6T6X/V4rNR0oeF+RYo1MAn2kO
bfk27H6uawYkf8eQT2vVFLON
=/urs
-----END PGP SIGNATURE-----