one more thing, U can write ur insert command as insert into tableb select * from tablea thus every time u add a column in a table, u don't need to mention it in insert command, '*' represents all columns
On Sunday, April 13, 2014 10:25 PM, rehan wyne <[email protected]> wrote: 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
