Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

0 Answers   MCN Solutions,

---

Why I have to use stored procedures?

0 Answers   Cognizant,

---

explain different types of jions with examples briefly?

3 Answers   Zensar,

---

What is Right Outer Join?

2 Answers  

---

What does top operator do?

0 Answers  

---

---

What is a db view?

0 Answers  

---

Hi, I have a table A which has four rows as follows Table A ------- empname salary ------- ------ A 1000 B 2000 C 3000 A 1000 B 2000 D 5000 I need the following output: empname salary ------- ------ A 1000 A 1000 B 2000 B 2000 Thanks in advance

10 Answers   IBM,

---

what's new in sql server 2016?

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,

---

Diffrences between sql server 2000 vs 2008

0 Answers   TCS,

---

What is apply operator in sql?

0 Answers  

---

What is the synonym of join?

0 Answers  

---