Answer / anand.kv

SELECT TOP 0 * INTO tableB FROM tableA

Answer / sunny

to copy only the structure
select * into table2 from table1 where 1=2
to copy the table along with the records
select * into table2 from table1 where 1=1

Answer / karthik

Create table emp1
as
select * from emp
where 1=2


It will give the structure of the table.

Answer / mits

Create table newtablename
from oldtablename
where 1=2

how do you test proper tcp/ip configuration windows machine? : Sql server database administration

0 Answers  

---

Consider a table with 8 rows 4 rows contains value 0 and 4 rows contains value 1.Now write a single update query to make all 0's as 1 and all 1's as 0

7 Answers   PMAM IT Services, TCS,

---

can any one post me, how to remove rows in the below table ENO ENAME EDEPT ELOC 3368 BPS BI Adayar 3371 RAN BI valachari 3369 SRI BI valachari 3372 jay BI Chn - - - - - - - -

2 Answers  

---

what is differencial backup?how to work?Anybody explai it?

2 Answers   HCL,

---

what is difference between Enterprise Manager and Query Analyer

6 Answers   CTS,

---

what is extended StoreProcedure ?

3 Answers   Satyam,

---

What is table level trigger?

0 Answers  

---

What is a trigger? Why we need it?

0 Answers   Accenture,

---

What is the difference between mysql and mysqli?

0 Answers   HCL,

---

Is it possible to update the views? If yes, how, if not, why?

0 Answers  

---

what is the diffrence between Snap Shot and Transaction Replication

2 Answers   CSC,

---

Explain the commands in sql server?

0 Answers  

---