Deborah Melkin - Single Statement, Many Changes
FREE @ VACO Technology • Hosted by SQL Server Users Group
You can only insert into, update, or delete from one table at a time. At least that's what we're told when we first learn to write SQL statements. However, the truth is that one data change could affect many other tables.