What is cursor in ms sql server?

0 Answers  

---

What do you understand by sql server agent?

0 Answers  

---

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

1 Answers   HCL,

---

How many jobs will create for Mirroring, Log Shipping, and Transactional Replication?

4 Answers   IBM,

---

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

2 Answers  

---

---

What is the difference between in and exists. Ex: select * from emp where empno in(....) and select * from emp where empno exists(....) What is the difference between a Join and Union and Union and UnionAll.

5 Answers   ABC, Accenture,

---

What is Pointer ?

3 Answers   Cap Gemini, CarrizalSoft Technologies,

---

What are the differences between UNION and JOINS?

3 Answers   CarrizalSoft Technologies,

---

you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration

0 Answers  

---

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 you can change a cross join into an inner join?

0 Answers  

---

How to get a list of all tables with "sys.tables" view in ms sql server?

0 Answers  

---