ALTER TRIGGER [dbo].[example]

ON [dbo].[exampleTable]

AFTER Update

AS

BEGIN

BEGIN TRY

SELECT 1/0

END TRY

BEGIN CATCH

END CATCH

END

trigger have error here,you dont update,I want trigger skip error,update run.

I want to update a table.even if A error occur in trigger,I want to update process complete.but when the error fall begin catch block, update dont complete.how I...

ok:)

thanks a lot:))