All my blogs with #SQLSERVERLearning is intended to cover all stuff identified as difference between Oracle and SQL Server.
Hopefully it might be helpful for Oracle guy also working in SQL Server world.
All finding or Observations with SQL Server for any Oracle guy can be access here.
With Oracle, SQL Developer and Toad console provide an option to export Table data from Result set itself.
With SQL Server, we would need to follow series of steps to export table as Insert statement.
Lets Iterate through steps to Export table data in SQL Server. (Tested on SQL Server 2012)
For demonstration purpose, we would take “AdventureWorks2012” database as sample data-set.
Step 4:Select Export Type for database object.
Click on Advanced option to change default export properties.
By default only Schema creation script can be exported, if data is also need we can select “Schema and Data Option”.
If only Data is needed, we can select only data options.
Using above steps, we can export complete set of records for a table.
But in case we need to export only specific set of records from a tables, not sure whether we have any option provided by SSMS.