How to create view in stored procedure sql server?

0 Answers  

---

What do you need to connect php to sql server?

0 Answers  

---

What is the beast way to write CTE in SQL Server ?

0 Answers   HCL,

---

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  

---

What is self join in sql server joins?

0 Answers  

---

What is temporal table?

0 Answers  

---

What is the filtered index?

0 Answers  

---

How to change location of errorlog in SQL?

2 Answers   ABC, IBM,

---

How to retrieve range of 10th rows to 20 th rows from total rows from a database table.? (Not from Dataset)

10 Answers   Cognizant, Infosys,

---

How many types of system privileges are there, Can we add or delete privileges?

2 Answers  

---

Explain the properties of a relational table?

0 Answers  

---

What is difference between commit and rollback when used in transactions?

0 Answers  

---