Forum Stats

  • 3,838,578 Users
  • 2,262,383 Discussions
  • 7,900,690 Comments

Discussions

trigger

658464
658464 Member Posts: 3
edited Sep 6, 2008 8:00PM in 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
Tagged:

Answers

  • JustinCave
    JustinCave Member Posts: 30,293 Gold Crown
    edited Sep 6, 2008 8:00PM
    This appears to be a duplicate of [your other thread|http://forums.oracle.com/forums/thread.jspa?threadID=703191&tstart=0]. I'll answer over in the PL/SQL forum.

    Justin

    Edited by: Justin Cave on Sep 6, 2008 8:00 PM

    Looks like Solomon just beat me to it.
This discussion has been closed.