I have some tables that have data there. My plan is to have one .sql to do the following:
1. The script will have create table code and all of the data in the table will be in the script as well.
for example. I have table customer and have column first name, last name with data John Smith.
I want to get script from sql server 2008. Included the table structure and the data into one script. Does it seem possible?