What is pessimistic concurrency?

0 Answers  

---

What is a view? is View updatable?

17 Answers   IBM, L&T,

---

I have a table EMP in which the values will be like this EmpId Ename Sal DeptId 11 Ram 10000 10 11 Ram 10000 10 22 Raj 20000 20 22 Raj 20000 20 33 Anil 15000 30 33 Anil 15000 30 I want to delete only duplicate Rows. After Delete I want the output like this EmpId Ename Sal DeptId 11 Ram 10000 10 22 Raj 20000 20 33 Anil 15000 30

13 Answers   DELL,

---

Can we add a cpu to sql server?

0 Answers  

---

Why union all is faster than union?

0 Answers  

---

What is the difference function and stored procedure?

0 Answers  

---

How to write a query with an inner join in ms sql server?

0 Answers  

---

hi, how to match retrieve the unmatched records from 2 tables in which we dont have any primary key. example : table1 has 1,2,3,4,5 and table2 has 1,2,3,4,5,6,7,8,9,10 and i want the numbers from 6 to 10 to be displayed and should not come as null. i need the numbers. please reply as soon as possible.

4 Answers  

---

what is the signification difference of this bit data type between sql 6.5 and later version sql server?

1 Answers  

---

How to delete particular value in the column of a table.Is it possible or not?if possible give it as in query.

8 Answers   Intelenet,

---

what is raid? : Sql server database administration

0 Answers  

---

What is blocking and how would you troubleshoot it?

2 Answers  

---