Everyone know how to script out a definition of a table. However many do not aware that you can script out data as well in the form of SELECT statements
This option is available only from SQL Server Management Studio (SSMS).
Here is what you need to do
Right click on database
–>tasks–>Generate scripts–>click next–>Choose specific database_objects
Now check out the tables you want to script data out
Choose one of the saving options (file, clipboard,etc).
Click Advanced and in the drop down for label Type of data to script , choose the value Data only
Click next. You get all the data in the form of SELECT statements
Here are the pictures for easy understanding
Advertisements
