This is very cool
Just found this fab, tool to generate all the insert statements you need from a SQL database.
If you have SQL Server 2008 R2 Installed -
Run
"C:\Program Files (x86)\Microsoft SQL Server\90\Tools\Publishing\1.4\SqlPubWiz.exe"

This lets you select individual tables, views, stored procedures and script out both data and schema structures.
Perfect for populating SQL Azure, when migrating from on-Premise databases.