which database is best to use in oracle and sql server? explain reasons?

5 Answers   TCS,

---

What are the main differences between #temp tables and @table variables and which one is preferred?

0 Answers  

---

What is difference between commit and rollback when used in transactions?

0 Answers  

---

how do you test proper tcp/ip configuration windows machine? : Sql server database administration

0 Answers  

---

What are the steps you will take to improve performance of a poor performing query?

1 Answers   HCL,

---

What is a materialized view?

3 Answers  

---

What specific conditions database should meet, before you can bulk copy data into it using bcp?

0 Answers  

---

When do u use clustered index and non-clustered index?

3 Answers   IBM,

---

Table student containing 2 columns,Join date,Employee name. Under join date 4 rows r ter =1-jan-2008,2-feb-2008,3-mar- 2008,4-feb-2008.Under Employee name 4 difeerent names jaison,robin,binoy,rahul Result set is, Table containing 4-column name=jan,feb,mar,april,,beneath these months count is given as 1,2,1,0 means these counts representing number of emplooyees joined in a month(january 1employee,february 2 employee,march 1 employee,april 0 employee) Can you give me the required sql query

3 Answers   RND Soft, Wipro,

---

How to insert multiple rows with one insert statement in ms sql server?

0 Answers  

---

what do you understand by change data capture?

0 Answers  

---

what's the difference between a primary key and a unique key? : Sql server database administration

0 Answers  

---