Posted by Erland Sommarskog on 06/26/06 22:45

Zvonko (zvonko_NOSPAM_@velkat.net) writes:
> I have a interesting problem. I need to write a trigger that wil go
> off after every sixth row is inserted/updated.

That is not really possible. For starters, a trigger fires once per
statement, so what if you insert 35 rows in one go?

I think you need to reformulate the requirement. What do you really
want to achieve?


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: dbcc reindex issue - - I don't understand!!
• Prev in forum: Re: need tool for managing database object ownership
• Thread view: Re: trigger question

[Reply to this message]