Insert is always preferred because append need database owner's password. On Sunday, April 13, 2014 8:51 PM, TOM HART <[email protected]> wrote: I used append many years ago, then went to insert, and want to know which is the preferred way? The reason I ask is because I have from time to time added a new column to a table and forgot to change the insert to reflect the change. eg:
project temptable from inventorytable using all where limit=0 add my data to temptable insert temptable into salestable My thought process is that if append is used I would not have to worry about changing my insert Tom Hart
