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);

What are logical database components? : SQL Server Architecture

0 Answers  

---

Write a SQL query in order to merge two different columns into single column?

0 Answers   QuestPond,

---

What are the triggers in sql?

0 Answers  

---

why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration

0 Answers  

---

What are commonly used odbc functions in php?

0 Answers  

---

How get current date in SQL server 2000

4 Answers   Cap Gemini, Polaris,

---

What is a field in a table?

0 Answers  

---

I have Two table First have UserName and second is address, in address table more than value relegated to UserName table, i want to fetch 2nd address if exist other wise 1st address access

4 Answers  

---

Can we store videos inside the sql server table?

0 Answers  

---

Which are the important points to note when multilanguage data is stored in a table?

0 Answers  

---

Can you index views?

0 Answers  

---

What are the advantages of passing name-value pairs as parameters?

0 Answers  

---