[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

SQL Server: generating inserts for the table data

Posted on 2014-08-08
3
Medium Priority
?
350 Views
Last Modified: 2014-08-22
I'd like to generate insert statements for each row in the table. What are my choices?
Thanks.
0
Comment
Question by:quasar_ee
  • 2
3 Comments
 
LVL 35

Accepted Solution

by:
David Todd earned 1500 total points
ID: 40250037
Hi,

Where is the current data? Where is it trying to go to? Why do you want insert statements and not, say, an export/import from csv?

Regards
  David
0
 

Author Comment

by:quasar_ee
ID: 40254648
just want to create insert scripts for the small test tables;
how does cvs handle difference between null and empty string?
0
 
LVL 35

Assisted Solution

by:David Todd
David Todd earned 1500 total points
ID: 40254658
Hi,

Can you give an example of the existing table?

Regards
  David
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Suggested Courses

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question