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,

---

How to run sql server 2005 books online on your local system?

0 Answers  

---

How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

0 Answers  

---

What do you mean by sql server 2005 express management tools?

0 Answers  

---

How can you ensure that the database and sql server based application perform well?

0 Answers  

---

---

what changed between the previous version of sql server and the current version? : Sql server database administration

0 Answers  

---

What is user defined datatypes and when you should go for them?

0 Answers  

---

How to retrieve duplicate rows in a table? How to delete the duplicate entries in a table?

15 Answers   Leo Technologies, Mannar Company, Synechron,

---

Can primary key be a foreign key?

0 Answers  

---

Explain the dbcc pintable command when would you use it?

0 Answers  

---

How would you retrieve Unique rows from table without using UNIQUE and DISTINCT keyword?

2 Answers   Genpact,

---

Tell me what are the advantages of using stored procedures?

0 Answers  

---