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)

What is a Join and explain its types?

0 Answers  

---

How will you decide the active and passive nodes?

0 Answers  

---

Diffrence between DTS vs SSIS

2 Answers   IBM, Infosys,

---

What is history table in sql server?

0 Answers  

---

How will you optimize a stored procedure optimization?

0 Answers  

---

---

What is t-sql script to take database offline – take database online.

0 Answers  

---

How to list all dsn entries on your local machine using odbc_data_source()?

0 Answers  

---

how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

0 Answers   United Healthcare,

---

What is default port number for sql server 2000?

0 Answers  

---

what is syntex second or third highest salary. thanks & Regards Dhirendra sinha

7 Answers  

---

What is raiseerror? What is raiseerror?

0 Answers  

---

Can we add our custom code in ssis?

0 Answers  

---