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
- 3082 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 is sleeping status in sql server?
Does view occupy space?
what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?
Explain “not null constraint” in sql server?
How do I shrink an ldf file?
Delete duplicate rows without using rowid.
How do I setup a local sql server database?
What is openxml in sql server?
What are sql server functions?
What's new in sql management studio for sql server? : sql server management studio
Explain indexes disadvantages?
What is executereader?
Explain what is dbcc?
What happens if you insert a duplicate key for the primary key column in ms sql server?
Describe how to use the linked server?
