Display a roll having miminum marks in two subjects?

7 Answers   Patni,

---

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,

---

Which tcl commands are available on the sql server?

0 Answers  

---

What is the importance of a recovery model?

0 Answers  

---

What is service broker? : sql server database administration

0 Answers  

---

What is explicit cursors?

0 Answers  

---

hi... this is charan.I persued btech in 2010 looking for a job on database/back-end as freehser. can any seggest me which course or back-end tool i have to learn

0 Answers  

---

How to filter out duplications in the returning rows in ms sql server?

0 Answers  

---

If there is failure during updation of certain rows, what will be the state?

2 Answers  

---

What is a sub-query? When would you use one?

3 Answers  

---

Why people hate cursor?

0 Answers  

---

How do I create an extended event in sql server?

0 Answers  

---