What is the log shipping?

0 Answers  

---

Why I can not enter 0.001 second in date and time literals in ms sql server?

0 Answers  

---

what are three different authentications to connect linked servers?

1 Answers   CitiGroup,

---

How do you delete duplicate rows in sql server?

0 Answers  

---

What is the difference between WHERE AND IN? OR 1. SELECT * FROM EMPLOYEE WHERE EMPID=123 2. SELECT * FROM EMPLOYEE WHERE EMPID IN (123) WHAT IS THE DIFFERENCE?

15 Answers   Adsys, Cap Gemini,

---

What is coalesce and check constraint in sql server?

0 Answers  

---

What is database architecture? : SQL Server Architecture

0 Answers  

---

List some of the rules that apply to creating and using a ‘view’

0 Answers  

---

Explain the database you used in your final year project?

0 Answers   Wipro,

---

explain query execution plan

1 Answers  

---

What is Schema? and why we use schemas?

4 Answers  

---

table:employee EID ENAME MID(manager ids) 101 rama null 102 sita 101 103 siva 101 104 ganesh 103 . . . . . . for 103 ID the manager ID is 101(RAMA) and for 104 manager is SIVA if i give employee id (EID) you have to tell the manager for that EID write query? eample:if i give 102 .The query output should be manager for 102 ID that it should print RAMA as output

7 Answers  

---