Ms Sql Server Create Table From Another Table

For the purpose we will use the method SELECT INTO :

This method is used when table is not created earlier and needs to be created when data from one table is to be inserted into newly created table from another table. New table is created with same data types as selected columns.

---- Create new table and insert into table using SELECT INSERT

SELECT Column1, Column2 INTO NewTable FROM oldTable WHERE 1 = 2

Th sql above will copy the structure only

To copy selected data too we need to do the same as :

---- Create new table and insert into table using SELECT INSERT

SELECT Column1, Column2 INTO NewTable FROM oldTable WHERE 

Download Vishalswami Toolbar

Hi all ,

Now you all can always stay in touch with the new developments of this site, by having the new vishalswami toolbar in your browser.
With that you will get :

1. The Best of Our Site
Get our freshest content delivered directly to your browser,no matter where you are on the Web.

2. Hand-picked Links
Check out all of our favorite places on the Web.

3. Google-Powered Search Box
Search the Web, our site, and other useful engines.

4. Alerts to Your Desktop
Receive our most important news and announcements instantly.

download and install the browser toolbar from here.