SQL adaptation guide For SQL SERVER 2005, 2008, 2012 / Data dictionary |
Informix® and Microsoft™ SQL SERVER provide triggers with similar features, but the programming languages are totally different.
Microsoft SQL SERVER does not support "BEFORE" triggers.
Microsoft SQL SERVER does not support row-level triggers.
Informix triggers must be converted to Microsoft SQL SERVER triggers "by hand".