Help with SQL or Trigger
I have a table with a "Active" bit column. I want only one one record to be marked as "Active". if I add a new record and set it to "active", is there a way with a trigger or SQL to automatically set all other records to "Active" = false.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER