How to fetch records from a One to Many relationship table. eg: wanna get details of all orders for a specific customer. (do not want repeatation of master table records for child table records)

2 Answers  

---

What are the types of constraints?

1 Answers  

---

What is scrollable cursor?

0 Answers  

---

What is the security model used in sql server 2005?

0 Answers  

---

How do I find the sql server instance name?

0 Answers  

---

---

I have student marks in a student table. I need second highest mark .Then what will the query for this?

37 Answers   NetCore, Patni, SAP Labs, Temenos, Wipro,

---

What is BCNF? How is it better than 2NF & 3NF?

0 Answers   Essar,

---

can you any body tell me while running BCP Out in instance in sql server 2000 is getting error. Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.?

1 Answers  

---

Explain subquery and state its properties?

0 Answers  

---

What's the difference between a primary key and a unique key?

10 Answers   Wipro,

---

What is the sql profiler?

0 Answers  

---

Tell me what is normalization? Explain different forms of normalization?

0 Answers  

---