Consider a table with 8 rows 4 rows contains value 0 and 4 rows contains value 1.Now write a single update query to make all 0's as 1 and all 1's as 0

7 Answers   PMAM IT Services, TCS,

---

Differentiate between SQL and ORACLE joins and write their syntax.

0 Answers   Global Logic,

---

What is buffer cash in sql server?

0 Answers  

---

How will you fine tune a stored procedure or what are the steps that should be taken to fine tune or optimize a stored procedure?

1 Answers   Logitech, Mphasis,

---

How to count groups returned with the group by clause in ms sql server?

0 Answers  

---

What are the properties of the transaction?

0 Answers  

---

What is difference between restoration and recovery in SQLServer?

3 Answers   Microsoft,

---

What are scheduled tasks in sql server?

0 Answers  

---

What are trace flags?

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,

---

Difference between sql server 2000 and sql server 2005?

11 Answers   Aditi Tech, eInfochips, GE, HCL, IBM, Masim Infotech, NIIT, Satyam, Systems Domain,

---

Can a trigger be created on a view?

0 Answers  

---