How can you see what type of locks used?

1 Answers  

---

What is blocking in SQL Server? If this situation occurs how to troubleshoot this issue

2 Answers   IBM,

---

How many types of Outer Joins?What are they?

1 Answers  

---

Do you know the cursor optimization tips?

0 Answers  

---

How do I start sql server?

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 is RMS migrations?

0 Answers   Satyam,

---

What does the on update no action do?

0 Answers  

---

What does the update command do?

0 Answers  

---

How to declare and use cursor variables?

0 Answers  

---

After using delete statement in sql query to delete some records...to retrieve the deleted records we can get using rollback command but till that where it stores means particular location name i need....(after deleting and rollback )

3 Answers   CarrizalSoft Technologies, iGate,

---

How to change the system date and time from SQL Plus Terminal ?

0 Answers   MCN Solutions,

---