Re: trigger each row

From: Thomas Steinmaurer (t.steinmaurer_at__no_upscene_spam_.com)
Date: 10/07/04 

Date: Thu, 7 Oct 2004 14:08:02 +0200

> If you *have* to call an SP for every row then you can only use a cursor
/
> WHILE loop approach. This is a poor solution. You should avoid using
> row-by-row processing in a trigger. Why can't you put the logic from your
SP
> into the trigger instead?

It's a pitty that MSSQL doesn't support row-level triggers at all. It
would make life in certain situations more easier.

Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database and MS SQL Server
Upscene Productions
http://www.upscene.com

Relevant Pages

  • Triggers, @@Identity and TADOQuery
    ... I am trying to set up simple auditing functionality for my users on ... MSSQL using the brute-force, trigger way. ... I create a trigger on MyTable which writes records into MyAuditTable. ...
    (borland.public.delphi.database.ado)
  • Re: Synchronisation MSSQL -> Postgres
    ... einbinden und direkt in einem Trigger oder einer stored procedure ... ODBC' klappt auch, ich habe mich beim Test an folgender Beschreibung ... kennt jemand eine gute Beschreibung für Trigger in MSSQL (für ...
    (de.comp.datenbanken.misc)
  • Performance question on triggers
    ... MSSQL 2000 Given a table ... x,a,b,c float ... by using a trigger: ... set nocount off ...
    (microsoft.public.sqlserver.programming)
  • Re: Creating a trigger in Pervasive SQL 2000i
    ... I've looked at the manual and created a trigger. ... In MSSQL, when I create a trigger I can see the file ... But in psql I can't find it. ... the pop-up window said "Stored Procedure was succesfully ...
    (comp.databases.btrieve)