Trigger In SQLserver

Hi friends,

We have triggers on each table in oracle database and none in sqlserver so far. But we are looking at creating triggers on sqlserver db's as well and I am trying to find the equivalent syntax for T sql..

In ORACLE, for edi_invoice column on EDI table:

CREATE OR REPLACE TRIGGER edi_trg
before insert or update ON edi for each row
begin

:new.EDI_INVOICE:= nvl(:new.EDI_INVOICE,' ');
end
/

I think in T SQL is should be like below?

CREATE TRIGGER edi_trg
ON edi
for insert or update
as

:new.EDI_INVOICE:= nvl(:new.EDI_INVOICE,' ');
go

Thanks much for all your help.