General Database Discussions

Please let me know the equivalents in T-SQL for the functions old and new functions in the oracle.

Also if some body let me know how to translate this

trigger into T-SQL.

create or replace TRIGGER "BILLINGDV".INS_ADD_CORR
BEFORE INSERT
on ISSUER_ADDRESS_CORRECTION



begin
@NEW.date_created = GETDATE() I M UNABLE TO CHANGE HERE
@NEW.date_modified = SYSDATE()
end