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

WRITE A FUNCTION TO DISPLAY THE OUTPUT OF AN EXISTING TABLE RANGE LIKE COMMAM SEPERATED VALUES LIKE RANGE1,RANGE2,...

2 Answers   TVS,

---

How do you delete a trigger?

0 Answers  

---

What do you mean by table and field in sql?

0 Answers  

---

Can we update data in a view?

0 Answers  

---

What is the difference between local and global temporary tables?

0 Answers  

---

Explain foreign key in sql server?

0 Answers  

---

An employee table, with the columns id, name, sal and dob. Query to select emp names of all highest salaries(there are 4-5 people having the same salary which happens to be the highest).

9 Answers   ADP,

---

How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?

0 Answers  

---

How to modify an existing stored procedure in ms sql server?

0 Answers  

---

Can we write a distributed query and get some data which is located on other server and oracle database?

0 Answers  

---

When would you use the stored procedures or functions?

0 Answers  

---

What is the purpose of the model database?

0 Answers  

---