Differentiate between sql temp table vs table variable?

0 Answers  

---

Can some one please help with a query which will take only max value of a column in a join.

2 Answers  

---

Is it possible to have clustered index on separate drive from original table location?

0 Answers  

---

In which tcp/ip port does sql server run? Can it be changed?

0 Answers  

---

what is the maximum size of a row in sql server 2000 and 2005

2 Answers  

---

---

What is the difference between HAVING clause and the WHERE clause?

7 Answers  

---

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

1 Answers  

---

Explain the properties of subqueries in sql server?

0 Answers  

---

A table contains list of customers and his city with other details. Each customer has a unique number and the table consists millions of data. Query is: I want to retrieve 10 customers from each city, no script, only from single query?

8 Answers   Infosys,

---

can you any body tell me which service pack is installed in the sql server?

3 Answers  

---

How to Update from select query in sql server?

0 Answers  

---

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,

---