i use few third party softwares. they r all having their own databases . but the data is repeated in all these databases - say a person is in all the three databases, but his name is stoared in diff format in all databases i want to create a centralised database ,and i dont want to re-enter the records . using the exisating records how can i build a centralised database?

1 Answers   Fidelity,

---

How many types of Outer Joins?What are they?

1 Answers  

---

how to update a null value field in sql server eg a table contains 3 fields id,name,salary and 3 records salary of 1 record is null i want update the nullfield 111 arun 300 112 ddd 200 113 ttt null i want to update table with add 100 to every record include null after updation the recrds should be 111 arun 400 112 ddd 300 113 ttt 100

6 Answers   ABC, HCL,

---

what is the difference between a primary key and a unique key? : Sql server database administration

0 Answers  

---

How do I list the available tables in a database I'm querying?

4 Answers  

---

---

What is the use of @@spid?

0 Answers  

---

how we can count records as a group of days like sum of records for(four mondays),(four tuesday)........ in a month. group the column for weekdays.

1 Answers  

---

Can you tell me the difference between DELETE & TRUNCATE commands?

15 Answers  

---

What is clustered primary key?

0 Answers  

---

Explain ranking functions?

0 Answers  

---

What are the different types of indexes?

0 Answers   Blue Star,

---

How to insert and update data into a table with "insert" and "update" statements?

0 Answers  

---