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.