What are the 3 types of schema?

0 Answers  

---

How to use linked server?

0 Answers  

---

How to select Distinct columns from the table, table having 20 columns and i want all coulmns

5 Answers   Wipro,

---

1. What is CUBE Operator? 2. what are the new data types are available in sql server 2008? 3. Inisde a nested queries, how many subqueries u can have?

3 Answers  

---

Explain triggers?

0 Answers  

---

---

What is a table called, if it has neither cluster nor non-cluster index? What is it used for?

0 Answers  

---

Differences between logshipping and mirroring

1 Answers   Microsoft, Syntel,

---

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  

---

When is the use of update_statistics command?

0 Answers  

---

When a primary key constraint is included in a table, what other constraints does this imply?

0 Answers  

---

What is blocking?

0 Answers  

---

1. How to fetch all the duplicate records from the table. 2. How to fetch the second highest salary from the table.

12 Answers   Accenture,

---