Problem: Recently I came across a scenario in which I need to cleanup data in a table which is having foreign key references to other db tables.
Solution: Using SQLSERVER Cascading rule you can update / delete the child records references. Click here to know more about this.
No comments:
Post a Comment