Why is the need for data conversion transformations?

0 Answers  

---

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,

---

9. Write a query to list a new column with the difference in temp of the cities Delhi and Mumbai, Mumbai and Jammu and soon. Consider the following table : City_id City Temp. 1 delhi 40 2 Mumbai 35 3 Jammu 32 4 Pune 18

2 Answers  

---

How to provide default values to function parameters?

0 Answers  

---

Write an SQL query if u want to select the data from one block which intern reflects in another block ? thanx,do reply

1 Answers   Covansys,

---

difference between sql server2000 and sql server2005

1 Answers   KPMG,

---

Difference between Cluster and Non-cluster index?

32 Answers   Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi,

---

What is the use of CASCADE CONSTRAINTS?

3 Answers  

---

List some major differences between triggers and stored procedures?

0 Answers  

---

What is merge statement?

0 Answers  

---

Explain hostprotectionattribute in sql server 2005?

0 Answers  

---

List some case manipulation functions in sql?

0 Answers  

---