can we call functions from stored procedure in SQL Server 2005 ? How?

3 Answers  

---

How many triggers are possible per table?

0 Answers  

---

What function does a database engine serve in the sql server?

0 Answers  

---

How to loop through the result set with @@fetch_status?

0 Answers  

---

What are different types of schemas?

0 Answers  

---

How many tables can be joined in SQL Server?

0 Answers   Cap Gemini,

---

How to disable triggers using "disable trigger"?

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  

---

Tell me what is fill factor?

0 Answers  

---

Can a database be shrunk to 0 bytes, if not, why?

0 Answers  

---

List the different types of joins?

0 Answers  

---

What is index in an assignment?

0 Answers  

---