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.



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...

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...

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
  • 633

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 ...

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] ...

浅谈SQL Server 2008中的Hints(提示)-三种不同类型的联接提示(Join Hints)、查询提示(Query Hints)、表提示(Table Hints)

SQL Server 2008中SQL应用系列--目录索引   SQL Server的系统查询过程负责在SELECT查询执行时候产生查询执行计划。SQL Server会“智能”地选择一个高效计划来取...