Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004

    Question Unanswered: Trigger: Before Insert

    Hi, i'm a newbie in writting trigger and stored procedure, need to get help on this:

    I cannnot find anyway to run the trigger before insert, anyway to do this?


  2. #2
    Join Date
    Jun 2003
    Provided Answers: 1
    Maybe an INSTEAD OF trigger would do what you want.

    If you are trying to modify data before it is inserted, you can probably accomplish the same thing with an INSERT trigger that modifies the data after insert.

    What are you trying to?
    If it's not practically useful, then it's practically useless.

    blindman "sqlblindman"

  3. #3
    Join Date
    Jan 2004
    Hi, thanks for the reply.

    As I understand that Oracle have a Before Insert in triggers. But cant find in SQL. This thread actually is related what I post in the topic to ask about how to use trigger to generat the primary key.

    Im try to use the BEFORE INSERT to modify the primary key. By using AFTER INSERT, it can't accomplish my objective. Thanks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts