I have a table emp , Fields with empname,dnname,dno,salary. now I want copy distinct salary with all emp detail from emp into new table which is not already exist in database. how would I do this ?

2 Answers   Techno Labs,

---

Explain about service Broker functions?

0 Answers  

---

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

0 Answers  

---

How to Run a Query on a Remote SQL Server?

2 Answers  

---

What is user stored procedure & it purpose?

4 Answers   Wipro,

---

---

What are pessimistic lock and optimistic lock?

0 Answers  

---

What is the process of normalising?

0 Answers  

---

What are the differences between substr and charindex in sql server.

0 Answers  

---

Differentiate between SQL and ORACLE joins and write their syntax.

0 Answers   Global Logic,

---

What is transaction ? Give me one example.

11 Answers   Melstar, Wipro,

---

When do you create cluster and noncluster index?

5 Answers   Satyam,

---

Can you create a logon trigger in sql server 2005 express edition?

0 Answers  

---