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  

---

How to Get the last identity value used

4 Answers  

---

How to create a scrollable cursor with the scroll option?

0 Answers  

---

Can we have more than one NULL in a column having unique constraint?

12 Answers   247Customer,

---

what is a cursor and what is its use?

2 Answers   L&T,

---

How to insert multiple rows with a subquery?

0 Answers  

---

What is use of attribute hierarchy optimized state? : sql server analysis services, ssas

0 Answers  

---

Can we create clustered index on non primary key column

20 Answers   ABC, CTS,

---

What the different components of Replication and what is their use?

0 Answers  

---

What is subquery explain with example?

0 Answers  

---

Explain various On-Delete options in a DB table. Which is the default option?

0 Answers   Akamai Technologies,

---

What is a domain constraint give an example?

0 Answers  

---