What does the not null constraint do?

0 Answers  

---

Wht is the difference between stored procedure and trigger

6 Answers   HCL, TCS,

---

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  

---

‘Order by’ is not allowed in a view how can you sort information from a view?

0 Answers  

---

Explain the different index configurations a table can have?

0 Answers  

---

What is candidate key with example?

0 Answers  

---

Does union all remove duplicates?

0 Answers  

---

What are the dmvs?

0 Answers  

---

What are three SQL keywords used to change or set someone?s permissions?

3 Answers  

---

What is the need for group functions in sql?

0 Answers  

---

What are the advantages of using stored procedures? Please don't simply say compilation time will be saved as they are already complied. Please specify some other advantages.

3 Answers   247Customer,

---

How would you Update the rows which are divisible by 10, given a set of numbers in column?

3 Answers  

---