problem with trigger

[Ammu]

Hi Friends

CREATE TRIGGER ins_trig AFTER INSERT ON withdraw
FOR EACH ROW
BEGIN
UPDATE bank_balance SET bank_balance.balance = bank_balance.balance-withdraw.amount WHERE bank_balance.acc_num=withdraw.acc_num;
END

It is not working .. Is this code is correct?
please help me friends

--Ammu

[Rabbit]

The correct syntax for a trigger in SQL Server is

CREATE TRIGGER triggername
ON tablename
AFTER INSERT AS
BEGIN 
   --Code Here
END

[Ammu]

thank you for your response