I have three tables in SQL Server 2008 and they all have the PK-FK-FK-relationship.
1st table: I have a column name with the name as "STATUS" that contains the value "active" or "inactive".
2nd table: I have the column with the name FKNEWLoanReviewfieldid, which has multiple values
3rd table: The column is FKWwarningtypeID that has different values.
I'm trying to create a trigger so if "FKWarningtypeID" is updated to a value 4, then first column value of status should be modified to active.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!