>I need to append a table from a SQL Server database into another table of the same name and same structure in another SQL Server database.
>
>In Visual FoxPro, this can be done with the APPEND FROM command. Is this a mystery or I couldn't find a command like for SQL Server? Do I have to do a Visual FoxPro program to loop for each record and insert them manually into the other table?

You can use INSERT-SQL (it's richer in SQL Server)