What is self contained scalar sub query?

0 Answers  

---

what is new philosophy for database devises for sql server 7.0? : Sql server database administration

0 Answers  

---

What is conditional split?

0 Answers  

---

What are transactions in sql?

0 Answers  

---

Explain different types of lock modes in sql server 2000?

0 Answers  

---

Is it ok to shrink transaction log?

0 Answers  

---

What is "scheduled jobs" or "scheduled tasks"?

0 Answers  

---

Diff. b/w Full Outer Join And Cross Join?

3 Answers  

---

Mention the command used to rename the database.

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 the types of backup and tell me the difference between full and differential backup?

4 Answers   CTS, TCS,

---

Can we use max in where clause?

0 Answers  

---