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,

---

What are Spatial data types in SQL Server 2008

0 Answers   Infosys,

---

How to rename an existing column with sql server management studio?

0 Answers  

---

What is the difference between clustered and non-clustered indexes in ms sql server?

0 Answers  

---

What are the various Isolation levels?

2 Answers   HP,

---

---

Explain forward - only cursors?

0 Answers  

---

How many clustered indexes there can be on table ?

0 Answers  

---

What is Online Index Rebuild Operation?

1 Answers  

---

How to get last system shutdown time in Sql server when restarted system?

1 Answers  

---

Will sql server 2005 allow you to reduce the size of a column?

0 Answers  

---

How to find the second highest salary of an employee?

0 Answers  

---

What is a Stored Procedure?

8 Answers  

---