How to create trigger to automatically sum fields

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • kanika bhagat
    New Member
    • Oct 2010
    • 1

    #1

    How to create trigger to automatically sum fields

    hi,
    I have one table student and three fields in it named mtt1,mtt2 and sum.I want to update sum automatically whenever there is a new value inserted in two fields mtt1 and mtt2 respectively.i want to do this only by using triggers angd nothing else.
  • ck9663
    Recognized Expert Specialist
    • Jun 2007
    • 2878

    #2
    Sounds like an assignment...

    Have you checked google yet?

    Good Luck!!!

    ~~ CK

    Comment

    Working...