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]