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 use “drop” keyword in sql server and give an example?

0 Answers  

---

How to create a new schema in a database?

0 Answers  

---

Why should you use or avoid select * statements?

0 Answers  

---

How can I know what locks are running on which resource?

0 Answers  

---

Can you explain what is the use of custom fields in report?

0 Answers  

---

What is for xml in sql server?

0 Answers  

---

What are the source of constraints?

0 Answers  

---

How do I create a stored procedure in sql server?

0 Answers  

---

In the below query i have performed the commit transaction statement but still the values after the save are not saved. Can you please let me know why are the statements after save are rolled back even after commiting the data. help me with the understanding declare @trans2 varchar(10)='transaction2' begin transaction @trans2 insert into emp values(100,'xy',600); save transaction @trans2 insert into emp values(200,'pq',700); insert into emp values(300,'pq',800); commit transaction @trans2 rollback tran @trans2

1 Answers   AllState,

---

What are the differences between char and varchar in ms sql server?

0 Answers  

---

Can foreign key be duplicate?

0 Answers  

---