Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 3023 Views
- Fidelity, I also Faced
- E-Mail Answers
Answer Posted / himanshu gupta
First try to convert all names into same format(normalize) and then will insert all details to centralized database excluding duplicate record.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are different types of constraints?
What is openxml in sql server?
What is intellisense?
What is the distinction amongst delete and truncate?
What stored by the master? : sql server database administration
Tell me something about security and sql azure?
Do you know how to send email from database?
Explain the truncate command?
What are the approximate numeric data types?
Explain iaas, paas and saas?
Explain ranking functions?
You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?
What is the recommended total size of your memory optimized tables?
How to copy the tables, schema and views from one sql server to another?
Name and describe few console utilities for ssrs?
