Explain the difference between primary keys and foreign keys?

0 Answers  

---

Which are the important points to note when multilanguage data is stored in a table?

0 Answers  

---

When would you use a before or after trigger?

0 Answers  

---

Where views are stored in 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  

---

---

Explain forward - only cursors?

0 Answers  

---

What are the advantages of using sql server over ms access or why should one use sql instead of ms access

2 Answers   CMS, Impetus,

---

What is update_statistics command?

0 Answers  

---

What is de-normalization in sql database administration? Give examples?

0 Answers  

---

How to defragment indexes with alter index ... Reorganize?

0 Answers  

---

What is the openxml statement in sql server?

0 Answers  

---

Is mysql the same as sql server?

0 Answers  

---