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 does the on update no action do?

0 Answers  

---

what do you understand by change data capture?

0 Answers  

---

there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration

0 Answers  

---

What is default port number for sql server 2000?

0 Answers  

---

what is the system function to get the current user's user id? : Sql server database administration

0 Answers  

---

What are security principals used in sql server 2005?

0 Answers  

---

can anybody tell us, how to select 2nd max salary from table. my id is ashish.akk@gmail.com

28 Answers   IBM, Symphony,

---

Explain transaction server isolation?

0 Answers  

---

What are the factors you will check for the performane optimization for a database query?

7 Answers   CarrizalSoft Technologies, DELL, SoftSol,

---

Explain what are various ways to enhance the ssrs report?

0 Answers  

---

What is the function of sql server agent windows service?

0 Answers  

---