What structure can you implement for the database to speed up table reads?

0 Answers  

---

How do use Having,Group by,Group function in SQL?

0 Answers  

---

ow to bring suspect mode datbase online from scratch

0 Answers  

---

Explain the concept of view and Types of views in SQL server?

0 Answers   HCL,

---

How to list all field names in the result set using mssql_field_name()?

0 Answers  

---

What are the main differences between #temp tables and @table variables and which one is preferred?

0 Answers  

---

How to define output parameters in stored procedures?

0 Answers  

---

What number aggregate functions are accessible there in sql?

0 Answers  

---

What are binary string data types in ms sql server?

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  

---

Do you know sql server 2008 introduces automatic auditing?

0 Answers  

---

How to Debug a Stored Procedure?

5 Answers   Allianz,

---