Generate INSERT statements from SQL Server table data

It is often necessary to copy data between two tables (for example between staging and production databases). SQL Server makes this task rather complicated (you have to resort to export/import). In MySQL it is possible to generate INSERT statements for all the records in a table, and some SQL Server client tools (such as the somewhat immature but excellent Toad) also do this.

The really low cost solution though is to use this stored procedure:
http://vyaskn.tripod.com/code.htm#inserts