I have the following UPDTAE TRIGGER and it will ALWAYS hit my check condition (RAISERROR) that is intended to stop duplicates. Can anyone tell me what I have wrong??? I am more of an Oracle person then SQL Server...
CREATE TRIGGER TrgBlockDup_Radio_Cd ON dbo.labor FOR UPDATE AS BEGIN
I hit the RAISERROR when I am updtaing a duplicate value and also when not.... It works fine on the NULL...
Thanks in advance, Miller
asked Feb 05, 2010 at 02:32 PM in Default
For an update trigger, you will have 1 or more rows in both
The second block will only execute if the
To stop duplicates, I believe you want to use an
answered Feb 05, 2010 at 03:23 PM
Tom Staab ♦