How many index can be created for single table

4 Answers   CarrizalSoft Technologies, Verizon,

---

How do I change my passwords (database, LDAP, and so on) without causing an outage?

0 Answers   IBM,

---

Tell me the difference between clustered and non-clustered index?

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,

---

your distribution database is full what will u do

0 Answers  

---

---

What is Right Outer Join?

2 Answers  

---

Can you force a query to use a specific index?

0 Answers  

---

Mention the command used to rename the database.

0 Answers  

---

I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration

0 Answers  

---

How can we use ConnectorJ JDBC Driver with MS SQL?

0 Answers   PUCIT,

---

What is a function? Give some example?

3 Answers  

---

How do I find query history in sql server?

0 Answers  

---