To generate SQL scripts for one or more tables along with their data, right click on the database and click on Tasks->Generate Scripts. Choose the object that you want to backup and click on Next.

On the next dialog window, choose the location for your script, and then click on Advanced. By default, SQL Server only generates the script for your schema. To change this, select “Schema and Data” under General->Types of Data to Script. Finish the dialog steps and your script for the schema as well as data will be generated.