Explain what is row_number function?

0 Answers  

---

Explain having clause and where clause?

0 Answers  

---

What are cursors? Name four types of cursors and when each one would be applied?

3 Answers   Adea Solutions,

---

A left outer join B B right outer join A gives the same result then what is the use of two?

1 Answers  

---

Why it is recommended to avoid referencing a floating point column in the where clause?

0 Answers  

---

what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?

0 Answers  

---

What is unique key constraint?

0 Answers  

---

Do you know what are different types of replication in sql server?

0 Answers  

---

What is nested transaction?

0 Answers  

---

If any possiable to use 2 primary key in single table? How many primary key & foreign key used in each table(min & max)?

3 Answers  

---

what is performance tunning in sql server ? explain.

1 Answers   Thomson Reuters,

---

Suppose in a situation if two list boxes are there and if you select multiple options based on that the options related to those selected items should display in second list box. Again if we select multiple items in second listbox then the related to those selected items should display . In this scenario how will you design database,tables?

1 Answers   HP,

---