I have a table Client. There are two columns Name and FathersName.
Now I need to check these two fields at the time of insert, the combination of these two fields shouldn't be repeated.
The possible solution was by creating the composite key or unique index which I've done already and the same thing wants to do using the trigger.
After the inserting the row no. 3 the trigger should be worked and delete that record with the message "This record is already exist, can't add".