XPost: microsoft.public.sqlserver.programming   
   From: reb01501@NOSPAMyahoo.com   
      
   Gene Wirchenko wrote:   
   > On Mon, 11 Apr 2011 14:55:38 -0400, "Bob Barrows"   
   >  wrote:   
   >   
   > [snip]   
   >   
   >> It is not a matter of wanting all the columns. It is a matter of   
   >> writing maintainable code that will not blow up just because a new   
   >> column is added.   
   >   
   >     Ironic.   
   >   
   >     In your scenario, if a column is added and the trigger is not   
   > modified, the table will not be properly updated because of the   
   > missing column.   
   >   
   But it will be expected. That's the difference. We will know upfront that   
   the trigger has to be updated when the table's design changes.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)