Mention the differences between sql server and mysql.

0 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  

---

How to convert a table data in XML format in sql server?

0 Answers  

---

Can we use trigger new in before insert?

0 Answers  

---

What is candidate key with example?

0 Answers  

---

---

How many partitions a clustered index has by default in sql server 2012?

0 Answers  

---

Where the sql logs gets stored?

0 Answers  

---

what is diffrent between store procedure and trigger

2 Answers  

---

Define Joins?

0 Answers   HCL,

---

How to include date and time values in sql statements?

0 Answers  

---

Do you know query execution plan?

0 Answers  

---

Does partitioning ssd reduce performance?

0 Answers  

---