How to export data from SQL Server

[DeveloperFusion]

Although we can generate SQL script from SQL server. But how we can export data alongwith SQL.

[sanereddy]

What kind of format do you want to export to. Just right click on the table you want to export to, you will see several options where you can export the data like flat file, comma delimitted and so on. if you would like to create insert statements with the data, let me know I can write one stored procedure for you pretty quickly.

Thanks,
sanereddy