What are the disadvantages of primary key and foreign key in SQL?

0 Answers   Alcatel-Lucent,

---

What is an identity?

0 Answers  

---

How to return the second 5 rows in ms sql server?

0 Answers  

---

What are different types of statement?

0 Answers  

---

What is de-normalization and when do you do it?

3 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  

---

Write an sql query to sort a table according to the amounts in a row and find the second largest amount.

0 Answers   Amazon,

---

What is sql server programming?

0 Answers  

---

What is the difference between varchar and nvarchar datatypes?

0 Answers  

---

How to check if a table is being used in sql server?

0 Answers  

---

Explain about service Broker functions?

0 Answers  

---

let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration

0 Answers  

---