In this video tutorial tutorial I will demonstrate you how to generate SQL Query Script for both schema and data using SQL Server management Studio 2012.
1. Right click on the database and select tasks --> generate scripts
2. Next --> select the requested table/tables (from select specific database objects)
3. Next -- >click advanced --> give types of data to script = "schema and data"
4. Next and click finish button.