What is normalization and denormalization in sql server?

0 Answers  

---

What is function of CUBE ?

0 Answers   HCL,

---

Does the unique constraint create an index?

0 Answers  

---

How do you implement session management in SQL Server mode?

0 Answers   Cap Gemini,

---

What is join query?

0 Answers  

---

What is PROJECTION Operation?

0 Answers   Infosys,

---

how to find nth highest salary

103 Answers   Cognizant, IBM, NexGen, Oracle,

---

what is raid and what are different types of raid configurations? : Sql server database administration

0 Answers  

---

When I run the sql server 2000 setup, it just hangs. What do I do?

0 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,

---

What are transactions and its controls?

0 Answers  

---

Does an index slow down updates on indexed columns?

0 Answers  

---