Answer / narendra

select *into newtable from oldtable.

Answer / mohammadali.info

Syntax #1 - Copying all columns from another table

The basic syntax is:

CREATE TABLE new_table
AS (SELECT * FROM old_table);


For example:

CREATE TABLE suppliers
AS (SELECT *
FROM companies
WHERE id > 1000);

Syntax #2 - Copying selected columns from another table

The basic syntax is:

CREATE TABLE new_table
AS (SELECT column_1, column2, ... column_n FROM old_table);


For example:

CREATE TABLE suppliers
AS (SELECT id, address, city, state, zip
FROM companies
WHERE id > 1000);

Syntax #3 - Copying selected columns from multiple tables

The basic syntax is:

CREATE TABLE new_table
AS (SELECT column_1, column2, ... column_n
FROM old_table_1, old_table_2, ... old_table_n);


For example:

CREATE TABLE suppliers
AS (SELECT companies.id, companies.address, categories.cat_type
FROM companies, categories
WHERE companies.id = categories.id
AND companies.id > 1000);

How to link tables in sql server?

0 Answers  

---

What is enhanced database mirroring in sql server 2008?

0 Answers  

---

Can sql servers linked to other servers like oracle?

0 Answers  

---

which one will take 1st priority in case of insert statement and select statement???

2 Answers   HCL,

---

tell me the disaster recovery plan

0 Answers   Microsoft,

---

What is the difference between clustered index and primary key?

0 Answers  

---

What Is Rdbms?

0 Answers   Accenture,

---

What is the difference between local and global temporary tables?

0 Answers  

---

What are the different ways you can create databases in sql server?

0 Answers  

---

Are connections to sql server encrypted?

0 Answers  

---

Which data type columns are the best candidates for full-text indexing?

0 Answers  

---

What is the need for indexing?

0 Answers  

---