What is referential integrity? What are the advantages of it?

4 Answers   Descon, Digital Domain,

---

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  

---

Explain what are the basic functions for master, msdb, model, tempdb databases?

0 Answers  

---

How many columns can we include on clustered index ?

0 Answers  

---

What are the types of lock supported by ?

0 Answers   HCL,

---

---

role of sql sever 2005 in database rather than any other database

0 Answers  

---

Can we use where and having clause together?

0 Answers  

---

What is INTVAL( )and where we use Plz any body help me

1 Answers  

---

How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?

0 Answers   MCN Solutions,

---

how many type of subquery?

2 Answers  

---

How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?

0 Answers  

---

What is a transaction and what are ACID properties?

14 Answers   Config Systems, IBM, TCS, Virtusa,

---