how to create a trigger to lock table for insertion

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Rohullah
    New Member
    • Mar 2010
    • 43

    #1

    how to create a trigger to lock table for insertion

    Hello

    I want to create trigger and that should lock table for
    insertion,delat ion,updation.

    how to do it?

    plz give me the best answer or idea.

    thank u.
  • ck9663
    Recognized Expert Specialist
    • Jun 2007
    • 2878

    #2
    Create an instead of trigger and rollback on everything.

    Happy Coding!!!

    ~~ CK

    Comment

    Working...