Answer / mohammadali.info

CREATE TABLE new_table
AS (SELECT * FROM old_table WHERE 1=2);

For example:

CREATE TABLE suppliers
AS (SELECT * FROM companies WHERE 1=2);

This would create a new table called suppliers that included all columns from the companies table, but no data from the companies table.

Answer / amit kumar sharma

Select * into newTable From oldTable where 1=2

The where condition 1=2 will never get true, so only the
column of table will appear and get copied to newTable.

If we remove the where condition table with data will copy
to newtable.

Answer / arun

Select top 0
into newtable
from oldtable

Explain sql delete command?

0 Answers  

---

What is failover clustering overview?

0 Answers  

---

Explain what is the main purpose of having conversation group?

0 Answers  

---

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

0 Answers  

---

Do you know what are the ways available in sql server to execute sql statements?

0 Answers  

---

If there is failure during updation of certain rows, what will be the state?

2 Answers  

---

can you tell me some sites name for sql server 2000 commands with example??? plz reply soon.

0 Answers  

---

What are the indexes in sql server?

0 Answers  

---

What is the difference between clustered and a non-clustered index?

0 Answers   NA,

---

Do you know the isolation level that sql server support?

0 Answers  

---

How will you go about resolving deadlocks?

0 Answers  

---

Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?

0 Answers   HCL,

---