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
- What is Psychology? - Main goals of psychology?
- How to create autocomplete textbox search using asp .net MVC c# application.
- How to add @media query in asp.net mvc razor view page I am getting syntax clashes?
- How to make youtube video responsive for website?
- SOLVED-Bootstrap 3 Glyphicons are not working
- Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.
- Unable to update the EntitySet 'table' because it has DefiningQuery and no DeleteFunction element exists in the ModificationFunctionMapping
- How to save the web page’s content and save into a string variable in c#?
Related Article