Error in "Before Insert Trigger" query

• ashok-831066

  Right there with Babe

  Points: 778

  More actions

  February 25, 2009 at 3:51 am

  #131396

  Hi Friends,

  I try to implement trigger for Before Insert.

  But i got an error. My trigger event is below.

  CREATE TRIGGER Trig_Insert_author

  BEFORE INSERT ON tblauthors

  AS DECLARE @au_id INT

  BEGIN

  SELECT @au_id=(SELECT au_id from inserted)

  SELECT *from authors

  ENd

  BEGIN

  DELETE FROM authors WHERE au_id=@au_id

  END

  My exception is :Incorrect syntax near 'BEFORE'. Please intimate me that what mistakes i have in my query.

  Hope yours reply.

  Regards

  Ashok

• iainthepitman

  SSCommitted

  Points: 1666

  More actions

  February 25, 2009 at 3:57 am

  #949859

  sql server only uses after and instead of triggers.

  http://msdn.microsoft.com/en-us/library/ms178134.aspx

• ashok-831066

  Right there with Babe

  Points: 778

  More actions

  February 25, 2009 at 4:02 am

  #949860

  Hi friend,

  Thanks for your reply.

  In which query language have a BEFORE TRIGGER

  Regards

  Ashok

• iainthepitman

  SSCommitted

  Points: 1666

  More actions

  February 25, 2009 at 4:19 am

  #949862

  oracle *spit* does. not sure about the others.

• Omprakash K Deshpande

  Say Hey Kid

  Points: 681

  More actions

  February 25, 2009 at 4:21 am

  #949864

  Its only in oracle