Import / Export database data with SQL Server Management Studio

I would like to import / export data using SQL Server Management Studio. I 开发者_如何学JAVAwould like to get the data in the form of queries. Can it be done ?

Thanks.

Right click on database -> Tasks -> Generate Scripts...

when you get to "set scripting options", click "Advanced", then "type of data to script", change from "Schema only" to "Schema and Data" or "Data only".

Check out SSMS Tools Pack - it offers many things, one of them being a function to generate INSERT statements from your database tables.