Home Forums SQL Server 7,2000 T-SQL call stored procedure from trigger RE: call stored procedure from trigger
sandy-833685
SSC Eights!
Points: 919
More actions
December 23, 2008 at 3:35 am
#916641
i had written these code
it give me syntax error
CREATE TRIGGER HeadCount AFTER INSERT ON table2
FOR EACH ROW BEGIN
IF(NEW. coulmn1>2 AND NEW. coulmn1 < 4 ) begin
exec HeadCountDetail(NEW.coulmn1,NEW.coulmn2);
END;