Which system table contains information on constraints on all the tables created?

2 Answers  

---

What is the difference between a unique key and primary key?

0 Answers  

---

How optimize sql query with multiple joins in sql server?

0 Answers  

---

Do you know what is openxml in sql server?

0 Answers  

---

What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?

0 Answers   QuestPond,

---

Explain about Joins?

0 Answers   Infosys,

---

Following are some of the question related to below mentioned query? select e1.salary from employee3 e1 where 2= ( select count(distinct(e2.salary)) from employee3 e2 where e2.salary>=e1.salary ) 1) What the query returns? 2) How it works? - Detail explanation (what the sub query does, why it is (where 2=)....etc...Please?

5 Answers  

---

Hi, I have a table A which has four rows as follows Table A ------- empname salary ------- ------ A 1000 B 2000 C 3000 A 1000 B 2000 D 5000 I need the following output: empname salary ------- ------ A 1000 A 1000 B 2000 B 2000 Thanks in advance

10 Answers   IBM,

---

How can we improve performance by using SQL Server profiler?

0 Answers   QuestPond,

---

How network traffic be reduced by using the stored procedure?

0 Answers   Accenture,

---

optimization techinques

0 Answers   Wipro,

---

Write a program using SQL queries to find a unique entry in a table.

0 Answers   Tech Mahindra,

---