Answer / Nirpendra Singh

Indexing in Microsoft Word is not related to database indexes. In Word, you can create an Index from the References tab.

What is the use of primary key?

1 Answers  

---

What is difference between ms sql and mysql?

1 Answers  

---

How do you optimize a stored procedure query?

1 Answers  

---

What is cte sql?

1 Answers  

---

Give which cursor is better for better performance means type of cursors?

2 Answers  

---

How to return multiple rows from the stored procedure?

1 Answers  

---

If the base table structure is changed what will happen to join index????

2 Answers  

---

how u can find the n row from a table?

19 Answers   Tech Mahindra,

---

What are the disadvantages of file system?

1 Answers  

---

Q1.all the depts which has more then 10 empls? Q2.all the dept which does not have any emply? Q3 all the emp which does not have any dept? Q4 get all the emply detais with the dept details it dept is exit otherwise any emp details? Q5 how to debugg the dynamic sql and packages?

2 Answers  

---

how can we replace the particular column value of a resulted set of executed query? I mean write down a sql query to chane the particular column's value of a resulted set of executed query

3 Answers  

---

How much does sql cost?

1 Answers  

---