INSTEAD OF triggers does not are the same thing as
*before action* trigger, when the concern is tables.
In tables, before action does not substitute the original
action, just adjust it to the rules of the DBA.

The only thing that INSTEAD OF behaves like *before action* is
with views.

On Tue, 8 Mar 2005 15:06:56 -0300, Gerson Machado wrote:

>
>You make a mistake, MS Sql Server (if version 2000) have INSTEAD OF for
>óbefore actionó triggers.
>
>
>
>Gerson
>
>
>
>
>
> _____
>
>De: Martijn Tonies [mailto:m.tonies@...]
>Enviada em: terça-feira, 8 de março de 2005 14:26
>Para: firebird-support@yahoogroups.com
>Assunto: Re: [firebird-support] Firebird to SQL server
>
>
>
>> >>What about stored procedures and triggers?
>> >
>> >
>> > The Firebird stored procedure language is very different from the
>> > MS SQL Server stored procedure language. This cannot be easily
>> > converted.
>>
>> Does anyone know of a language comparison between Firebird / InterBase
>> and MSSQL procedure/trigger languages?
>
>I don't. I can tell you one thing though --
>
>MS SQL Server doesn't support "before action" triggers.
>
>With regards,
>
>Martijn Tonies
>Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
>Server
>Upscene Productions
>HYPERLINK "http://www.upscene.com"http://www.upscene.com
>
>
>
>
>
>
>Yahoo! Groups Sponsor
>
>
>
>ADVERTISEMENT
>HYPERLINK
>"http://us.ard.yahoo.com/SIG=12987tc6r/M=298184.6018725.7038619.3001176/D=gr
>oups/S=1705115386:HM/EXP=1110391202/A=2593423/R=0/SIG=11el9gslf/*http:/www.n
>etflix.com/Default?mqso=60190075"click here
>
>
> HYPERLINK
>"http://us.adserver.yahoo.com/l?M=298184.6018725.7038619.3001176/D=groups/S=
>:HM/A=2593423/rand=284412849"
>
>
>
> _____
>
>Yahoo! Groups Links
>
>* To visit your group on the web, go to:
>HYPERLINK
>"http://groups.yahoo.com/group/firebird-support/"http://groups.yahoo.com/gro
>up/firebird-support/
>
>* To unsubscribe from this group, send an email to:
>HYPERLINK
>"mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe"fir
>ebird-support-unsubscribe@yahoogroups.com
>
>* Your use of Yahoo! Groups is subject to the HYPERLINK
>"http://docs.yahoo.com/info/terms/"Yahoo! Terms of Service.
>
>
>--
>No virus found in this incoming message.
>Checked by AVG Anti-Virus.
>Version: 7.0.308 / Virus Database: 266.6.4 - Release Date: 7/3/2005
>
>
>
>--
>No virus found in this outgoing message.
>Checked by AVG Anti-Virus.
>Version: 7.0.308 / Virus Database: 266.6.4 - Release Date: 7/3/2005
>
>
>
>[Non-text portions of this message have been removed]
>
>
>
>
>Yahoo! Groups Links
>
>
>
>
>
>
>