SQL Server: How do I generate the table schema and populate it with inserts in a script?

Posted by Paula DiTallo on Geeks with Blogs See other posts from Geeks with Blogs or by Paula DiTallo
Published on Tue, 20 May 2014 10:46:23 GMT Indexed on 2014/05/26 21:29 UTC
Read the original article Hit count: 377

Filed under:

Practical Answers

|

sql

Originally posted on: http://geekswithblogs.net/AskPaula/archive/2014/05/20/156469.aspx

In SSMS, there's a Generate Script utility (read: only available under version 2008 and up) .

Here are the steps you would need to take to make use of the utility:

Right click on the database you're interested in and go to Tasks -> Generate Scripts
Select the tables and/or any other objects you'd like in order to get them into the script.
Navigate to Set scripting options. Click on Advanced.
Under the General category, navigate to Type of data to script
Select the Schema and Data option to get the insert statements generated. Click OK.

© Geeks with Blogs or respective owner

Related posts about Practical Answers

SQL SERVER – Interview Questions & Answers Needs Your Help

as seen on SQL Authority - Search for 'SQL Authority'
About an year ago, I had posted SQL Server related Interview Questions and Answers. It was very well received in community. I have received many comments, suggestions and emails on this subject. I am planning to upgrade the Interview Questions and Answers and take it to next level. Here, I need your… >>> More
How do I do event handling in php with html?

as seen on Stack Overflow - Search for 'Stack Overflow'
I am constructing a simple quiz using html and php. The problem I'm having is that I'm not sure how to do event handlers since it's my first time doing php. Simply, the user click on Take Quiz and it brings up the quiz, then submit the quiz using the same page and show score results. The quiz was… >>> More
Questions and Answers: Loopback devices

as seen on Internet.com - Search for 'Internet.com'
<b>Distrowatch:</b> "Going-around-in-circles asks: What is a loopback device and how do I use it?" >>> More
SQL SERVER Interview Questions & Answers Needs Your Help

as seen on Dot net Slackers - Search for 'Dot net Slackers'
About an year ago, I had posted SQL Server related Interview Questions and Answers. It was very well received in community. I have received many comments, suggestions and emails on this subject. I am planning to upgrade the Interview Questions and Answers and take it to next level.Here, I need your… >>> More
How do I know what Version of BizTalk is on my server?

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
Originally posted on: http://geekswithblogs.net/AskPaula/archive/2013/07/02/153324.aspxThere are 2 ways to do this, the first is to query the BizTalkDBVersion table:use [BizTalkMgmtDb]goSELECT DatabaseMajor, DatabaseMinor,ProductBuildNumber, ProductRevision FROM dbo.BizTalkDBVersion; Here is a list… >>> More

Related posts about sql

SQL SERVER – Concat Strings in SQL Server using T-SQL – SQL in Sixty Seconds #035 – Video

as seen on SQL Authority - Search for 'SQL Authority'
Concatenating string is one of the most common tasks in SQL Server and every developer has to come across it. We have to concat the string when we have to see the display full name of the person by first name and last name. In this video we will see various methods to concatenate the strings. SQL… >>> More
SQL SERVER – Concat Function in SQL Server – SQL Concatenation

as seen on SQL Authority - Search for 'SQL Authority'
Earlier this week, I was delivering Advanced BI training on the subject of “SQL Server 2008 R2″. I had great time delivering the session. During the session, we talked about SQL Server 2010 Denali. Suddenly one of the attendees suggested his displeasure for the product. He said, even though… >>> More
Error with SQL Server Setup 2012 on Windows 2012

as seen on Server Fault - Search for 'Server Fault'
I am trying to install SQL Server on Windows 2012. I was able to finally get the wizard up and running after making some changes on the server, but now it fails no matter what I do with the following error: TITLE: SQL Server Setup failure. SQL Server Setup has encountered the following error: … >>> More
How can I detect which version of SQL (eg SQL 2008 or SQL Azure)

as seen on Stack Overflow - Search for 'Stack Overflow'
I need to detect which version of SQL I am dealing with to perorm various tasks, I need specifically detect if I am on SQL 2008 or SQL Azure. How can I do this with detection code written in SQL? >>> More
Nested SQL Select statement fails on SQL Server 2000, ok on SQL Server 2005

as seen on Stack Overflow - Search for 'Stack Overflow'
Here is the query: INSERT INTO @TempTable SELECT UserID, Name, Address1 = (SELECT TOP 1 [Address] FROM (SELECT TOP 1 [Address] FROM [UserAddress] ua INNER JOIN UserAddressOrder uo ON ua.UserID = uo.UserID WHERE ua.UserID = u.UserID ORDER BY uo.AddressOrder ASC) q ORDER BY AddressOrder… >>> More