What do you mean by an execution plan? How would you view it?

0 Answers  

---

What is default constraint?

0 Answers  

---

What is in place upgrade in sql server?

0 Answers  

---

I have to display ten columns values from diffrent ten tables. how many joins are require?

10 Answers   CarrizalSoft Technologies, HCL,

---

What is explicit cursors?

0 Answers  

---

---

What are the two types of concurrency?

4 Answers  

---

Hi all, I need query help for below senorio, could you please help me. TableName = City CITYID ContinuationID CITYNAME 1 1 SAN 1 2 DIEGO 2 1 SAN 2 2 FRANCISCO 3 1 CHICAGO 4 1 NEW 4 2 YORK 4 3 CITY Could you please help me to write a generalized SQL that returns results as given below in the Query result CITYID NAME1 NAME2 NAME3 NAME4 NAME5 1 SAN DIEGO 2 SAN FRANCISCO 3 CHICAGO 4 NEW YORK CITY

5 Answers   TCS,

---

Difference between group by clause and having clause in SQL?

0 Answers   Flextronics,

---

What are statistics?

0 Answers  

---

How to select an exiting database using mssql_select_db()?

0 Answers  

---

How to delete particular value in the column of a table.Is it possible or not?if possible give it as in query.

8 Answers   Intelenet,

---

What is query optimization process?

0 Answers  

---