pls suggest me with why it is so

• sanjiv pandey

  Newbie

  Points: 1

  More actions

  March 10, 2005 at 8:28 am

  #68388

  if suppose i am having a before Insert Trigger and a constraint on the same table then which will fire first and why .

  thanx.

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  March 10, 2005 at 8:56 am

  #546400

  Can't really explain why except that it makes more sens that way... but see for yourself :

  CREATE TABLE MyTest(

  Atest varchar(50) not null,

  constraint ck_test_ATest check (ATest = '1')

  )

  GO

  CREATE TRIGGER [trMyTest_IO_Insert] ON [dbo].[MyTest]

  INSTEAD OF INSERT

  AS

  raiserror ('trMyTest_IO_Insert', 13, 1)

  GO

  Insert into MyTest (ATest) values ('This fails the check constraint')

  --FAILS on the instead of insert trigger

  GO

  drop table MyTest