rodgersem (8/9/2013)

---

Hello -

I'm new to SQL Server and this forum. I'm trying to convert a simple Oracle trigger to SQL Server 2008. I know the BEFORE needs to be converted to INSTEAD OF but have no idea of the nomenclature. Thanks in advance, any assistance is appreciated.

CREATE OR REPLACE TRIGGER SET_COMBINELIKECATEGORIES

BEFORE INSERT ON CATEGORY

FOR EACH ROW

BEGIN

:new.combinelikecategories := 0;

END;