Answer / manoj

insert into <table_name> (<col1>,<col3>)
values(<val1, val3)

Answer / rajkumar

Format
------
Inser into <tablename> (column name) select (column name)
from <tablename> where <Condition>

Example
--------
INSERT INTO emp (empname) SELECT empname from employe WHERE
empid=5

Answer / srinivas

insert into <table_name> ( <col1> ,<col3>) values ( val1,val2)

How to delete duplicate records based on single column from a table?

0 Answers   Petranics Solutions,

---

What is Index ? Explain its Types?

2 Answers   ADP,

---

how many layers of tcp/ip protocol combined of? : Sql server database administration

0 Answers  

---

How to sort the query output with order by clauses in ms sql server?

0 Answers  

---

How do I view a stored procedure in sql server query?

0 Answers  

---

---

Normalization and denormalization

3 Answers   Wipro,

---

How to defragment indexes with alter index ... Reorganize?

0 Answers  

---

What are the differences between UNION and JOINS?

3 Answers   CarrizalSoft Technologies,

---

Explain what is the difference between union and union all?

0 Answers  

---

What is the purpose of sql profiler in sql server?

0 Answers  

---

What is the difference between osql and query analyzer?

0 Answers  

---

What is oltp (online transaction processing)?

0 Answers  

---