thanx alot!!!!

Just wondering!!! Can it work for two more tables? I have three tables. one called "sales", another "hr" and another "it"...

Can you please help me write now?  I am not that good @ triggers!!!

thanx for your response!!!

i have another table for the heads of the respective departments who have a unique salary!!

the sales department table is only  for workers or employees in the department!!!...

sorry about that i double posting bcoz my internet connection is slow so i refreshed the page again!!! when i noticed i had double posted i tried find where to...

thanks alot.... i will use both and see....

have a great week

nforchange

thanks. i will use it

these is how my table should look like

sno |Names |mark1 |mark2 |mark3 |mark4 |Total

Correct me if im wrong any where below:-

---------------------------------------

set nocount on

use tempdb

go

create table class(...

i can use an online documentation... I just need a script that is almost connected to my assignment...

have a great week.... the clocking is ticking towards Easter and my Stomach...

Im a newbie in sql. i started learning SQL at the begining of february...

the assignment is a class assignment... Do you know any free online sql server? Any site with...

what is BOL for CREATE TRIGGER?