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 fix "Jupyter notebook not opening problem"
- How to fix Task host windows prevents shutdown in windows 10
- Missing Module Docstring Pylint Error in Visual Studio Code
- Python was not found. run without arguments to install from the Microsoft Store - SOLVED
- How to set background for text using Graphics.DrawRectangle in c#?
- How to replace button click event with keyboard shortcuts - JQuery
- Attempted import error: 'Switch' is not exported from 'react-router-dom' - ReactJS
- How to dynamically change the image source using jQuery?
Related Article