What is the need for group functions in sql?

0 Answers  

---

What is difference between index seek vs. Index scan?

0 Answers  

---

Explain system scalar functions?

0 Answers  

---

How to execute multiple stored procedures at one time in sql server?

0 Answers  

---

I am having table Title with TITLE id,Author ID, Publiser ID , table AUTHOR with Author ID, Author Name, table PUBLISER with Pub ID, Pub name Here hot to find out the publiser id who have relesed the books of patriticular author?

3 Answers  

---

how can do you the system monitoring?

1 Answers  

---

how we use window authentication connection with sql server.?

0 Answers   MCN Solutions,

---

What is the difference between DataRow.Delete() and DataRow.Remove()?

0 Answers  

---

When we can say that is in BCNF?

3 Answers   BitWise,

---

1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.

0 Answers   Aptroid,

---

What are the types of database recovery models?

0 Answers   HCL,

---

Advantages and disadvantages of stored procedures.

2 Answers   HCL,

---