RETURN - inside a trigger

• Santhoshkumar KB

  SSCertifiable

  Points: 5066

  More actions

  July 2, 2009 at 8:36 am

  #132463

  Hi,

  create trigger dbo.trgMyTable_OnInsertUpdate on MyTable

  FOR UPDATE,INSERT AS

  --========Perform something========

  BEGIN

  --code

  END

  IF not UPDATE(someColumn)

  RETURN

  --=========SQL statements continues=======

  BEGIN

  --code

  END

  suppose "someColumn" is not updated

  in this case, will the SQL statements after IF condtion executes or not?

  Thanks,

  KB

  Thanks,
  Santhosh
  

  ---

  Human Knowledge Belongs To The World !!

• stopitallready

  SSC Eights!

  Points: 800

  More actions

  July 2, 2009 at 12:26 pm

  #1019390

  Why don't you state that:

  IF UPDATE(someColumn)

  BEGIN

  --code

  END

  This will only process if your desired column gets updated.

  Eli

• OTF

  SSCertifiable

  Points: 6104

  More actions

  July 2, 2009 at 2:51 pm

  #1019480

  Regardless of how you code it, I think you will find that the Return keyword should exit a Trigger / Procedure unconditionally.