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 change the ownership of a schema in ms sql server?

0 Answers  

---

which database is best to use in oracle and sql server? explain reasons?

5 Answers   TCS,

---

Can we use where clause with group by?

0 Answers  

---

What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security

0 Answers  

---

Which sql server table is used to hold the stored procedure scripts?

0 Answers  

---

What are various limitations of the views?

0 Answers  

---

Hi Can any one tell me the Good institute to learn SQL esp for Data Base Testing or SQL from scratch to the proficiency level in Hyederabad and facult also. Thankyou well in advance

6 Answers  

---

What are subqueries in sql server?

0 Answers  

---

Explain the commands in sql server?

0 Answers  

---

Can you explain what are various ways to enhance the ssrs report?

0 Answers  

---

What does it mean if @@cursor_row returns a negative number?

0 Answers  

---

Explain the properties of a relational table?

0 Answers  

---