I am working on SQL Server 2008R2
, I am having the following Table
ID Name date
1 XYZ 2010
2 ABC 2011
3 VBL 2010
Now i want to prevent insertion if i have a Data although the ID is different but data is present
ID Name date
4 ABC 2011
Kindly guide me how should i write this trigger.
See Question&Answers more detail:os