sql server 2008 copy data from one table to another

原创 2012年03月25日 23:03:23

Let us take a look at an example where we will generate script database. In our example, we will just take one table for convenience.

Right Click on Database >> Tasks >> Generate Scripts >>

This will pop up Generate SQL Server Scripts Wizards >> Click on Next >> Select Database >> This will bring up a screen that will suggest to Choose Script Option.

On Choose Script Option Screen of Script Wizard under section Table/View Options Look at Script Data row and Turn the Option to True.

The Next Screen will ask about object types. Select all the objects that are required in the generated script. Depending on the previous screen it will show few more screen requesting details about the objects required in script generation.

On the very last screen it will request output options. Select the desired output options of Script to file, Script to Clipboard or Script New Query Window.3

Clicking on Finish button will generate a review screen containing the required objects along with script generating data.

Clicking on Finish button one more time will generate the requested output.

Similarly, if you want to generate data for only one table, you can right click on the table and follow almost a similar wizard. I am sure this neat feature will help everybody who has been requesting for it for a long time.

CentOS7下Elastic Stack 5.0日志分析系统搭建

一、概述        Elasticsearch是个开源分布式搜索引擎,它的特点有:分布式,零配置,自动发现,索引自动分片,索引副本机制,restful风格接口,多数据源,自动搜索负载等。 ...
  • amm28824
  • amm28824
  • 2017年01月08日 21:47
  • 1848

SQL*Plus copy 命令处理大批量数据复制

对于数据库表级上的数据复制,我们最常用的是CREATE TABLE AS(CTAS)..方式。其实在SQL*Plus下面copy命令可以完成同样的工作,而且更加出色,性能也比较优异。更突出的是支持跨平...
  • robinson_0612
  • robinson_0612
  • 2013年05月02日 09:36
  • 5424


PHPMailer邮件类使用错误分析 一,没有定义发送邮箱$mail->From或格式不正确,错误提示:Language string failed to load: recipients_fail...
  • haiqiao_2010
  • haiqiao_2010
  • 2013年01月30日 17:56
  • 39090

config gateway config from oracle to sql server 2008

  • 2017年01月24日 16:07
  • 1.12MB
  • 下载

Error message when you try to save a table in SQL Server 2008: "Saving changes is not permitted"

SYMPTOMS When you use Data Definition Language (DDL) to modify a table, and then you try to save th...
  • tswisdom
  • tswisdom
  • 2011年11月29日 23:11
  • 1152

SQL Server 2008 Entity Data Model 和 Linq to Entities

转自:http://www.xker.com/page/e2009/0415/71272_4.html SQL Server 2008 带给大家的新特性之一就是 Entity Data Mode...
  • anyqu
  • anyqu
  • 2012年07月19日 09:27
  • 679

Export table data sql scrpit on sql server 2008

Since this is my first time working on sql server, I didn't know how to export data. Previously, I w...
  • smile_juan
  • smile_juan
  • 2012年12月12日 00:38
  • 2058

Beginning SQL Server 2008 for Developers From Novice to Professional

  • 2008年10月03日 20:43
  • 17.42MB
  • 下载

ABAP to copy aggregates from one cube to another

In COPA you have often a data model consisting of similar cubes butwith different data.You can have ...
  • zhongguomao
  • zhongguomao
  • 2011年08月23日 11:30
  • 540

How to export/import data with LOB type from one user/schema to another

How to export/import data with LOB type from one user/schema to another? [ID 464558.1] ...
  • tswisdom
  • tswisdom
  • 2012年02月16日 18:13
  • 900
您举报文章:sql server 2008 copy data from one table to another