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

Is mysql the same as sql server?

0 Answers  

---

What do you understand by hotfixes and patches in sql server?

0 Answers  

---

Is it possible for a stored procedure to call itself or recursive stored procedure?

0 Answers  

---

Write a SQL query to delete a table?

0 Answers   Amdocs,

---

Which command executes the contents of a specified file?

2 Answers   ABC, InfoMedia,

---

to explain sql server 2000 architecture & authentication

1 Answers   HCL,

---

How to use subqueries with the exists operators in ms sql server?

0 Answers  

---

What is a result set object returned by odbc_exec()?

0 Answers  

---

What is auditing in sql server?

0 Answers  

---

What is a Trace frag?Where can we use this?

1 Answers  

---

Do you know the different ddl commands in sql?

0 Answers  

---

A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?

0 Answers  

---