What is a trace frag? Where do we use it?

0 Answers  

---

Write an sql query to find the names of employees start with ‘a’?

1 Answers  

---

SYNTAX FOR VIEWS WITH EXAMPLE HOW TO LINK TWO TABLES

1 Answers   Microsoft,

---

How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

0 Answers  

---

Accidentally i deleted my table. How can i get that table?

4 Answers  

---

---

What is indexed views? plz explain with example?

2 Answers  

---

How would you use user_constraints table in DB?

0 Answers   Wipro,

---

What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?

0 Answers  

---

How to display a past time in days, hours and minutes?

0 Answers  

---

Describe about first three Normal forms.

1 Answers   HP,

---

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 the maximum size of a dimension? : sql server analysis services, ssas

0 Answers  

---