I have created a trigger which updates the correspondign LogTable for PrimaryTable. If the insert to LogTable would create a duplicate row then the trigger should take no action and should return. Could you tell me how could I achieve this? I have all columns as a primary key in LogTable. It is intentional but I don't want my trigger to fail if tried to insert duplicate row and rollback the transaction. It should not take any action(should not insert duplication row) and returns when duplicate row is recognized.
Thanks,
Dipti
Есть вопросы? Напишите нам!
Соглашаюсь с условиями обработки персональных данных
✖
By continuing to browse this website, you agree to the use of cookies. Go to Privacy Policy.