Answer Posted / 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 is the command dbcc checkdb used for?

963

---

What is the use of for clause?

1034

---

How to download and install microsoft sql server management studio express?

974

---

How many levels of sp nesting are possible?

958

---

Can you move the resources after pausing the node? : sql server database administration

1042

---

What is checkpoint process in the sql server?

961

---

How many types of stored procedures are there in sql server?

952

---

How we can refresh the view?

1056

---

What is scd (slowly changing dimension)? : sql server analysis services, ssas

952

---

Explain the truncate command?

918

---

What is the difference between stored procedure and user defined functions?

1128

---

What can be used instead of trigger?

1097

---

hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

2027

---

explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?

2424

---

Explain acid?

1017

---