How to connect PK and FK?

2 Answers  

---

A table contains list of customers and his city with other details. Each customer has a unique number and the table consists millions of data. Query is: I want to retrieve 10 customers from each city, no script, only from single query?

8 Answers   Infosys,

---

How do you check sql server is up and running?

0 Answers  

---

select top 5 * from emp order by newid() my question is , how this query get executed?

5 Answers  

---

You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

0 Answers  

---

What is order of B+tree?

0 Answers   HCL,

---

1.What is the deferece between DBMS & RDBMS? 2.How can you trouble shoot? If u will get error while installing sql server? 3.How can u trouble shoot slow running query? 4.how can u trouble log shipping errors? 5.why do we use merge replication instead of T.log replication?

7 Answers   Microsoft,

---

What is normalization? What number of normalization shapes are there?

0 Answers  

---

What is the meaning of sql server?

0 Answers  

---

How is a full-text index updated?

0 Answers  

---

Why we are using the sql language?. What is the purpose of using this?

2 Answers  

---

How do we return a record set from a Stored Procedure in SQl server 2000?

3 Answers  

---