RE: BEFORE TRIGGER Idea Posted to Microsoft Connect

SSC Guru

Points: 442467

May 22, 2017 at 1:10 pm

#1943641

Chris Harshman - Monday, May 22, 2017 12:10 PM
Lynn Pettis - Monday, May 22, 2017 10:34 AM
InterBase had both BEFORE and AFTER Triggers. I liked that as well, and having them in SQL Server would be a great addition.
Wait... there's actually someone else besides me who's actually worked with InterBase??? I've worked with BEFORE triggers in Oracle and InterBase, and I've found using INSTEAD OF triggers to be a clumsy substitute... I've also voted for it

Briefly, we were actually comparing SCO/Unix, InterBase, and Delphi against Windows NT 4.0, SQL Server 6.5 and VB 6 at a previous employer. MS won out, but look where I am today. Not sure that would have happened with other option. I did like InterBase as a database system, our developer however found it a bit difficult to work with from VB 6.