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.
Post your comments / questions
Recent Article
- How to load data from json file in angular?
- cannot find module consider using '--resolvejsonmodule' to import module with json extension angular
- How to create multi select dropdown in Angular?
- Argument of type 'string | null' is not assignable to parameter of type 'string'.\n Type 'null' is not assignable to type 'string'
- No 'access-control-allow-origin' header is present on the requested resource Angular CORS policy Error
- Access denied sql server attach database
- Visual studio Code change default terminal to cmd
- How to attach database in sql server using cmd?
Related Article