Generating SQL queries with full table data

I need to generate SQL queries with all table records, using SQL Server Management Studio Express. I know how to generate queries开发者_高级运维 for creating database itself, and full database structure: tables, views and stored procedures. Is it possible to make queries with all table content?

You can use the Database Publishing Wizard to script your data (along with scripts for schema)

This works with 2005 and can be used to generate scripts for schema only, data or both.

It generates a single SQL script file which can be used to recreate the contents of a database by manually executing the script on a target server.

The pre-requisite for Database Publishing Wizard is .NET 2.0 Framework, SQL Server 2005 Management Objects (SMO is included for use with SQL Express)