1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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?

Question Posted / guest


i use few third party softwares. they r all having their own databases . but the data is repeate..

Answer / 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

More SQL Server Interview Questions

How you can get a list of all the table constraints in a database?

0 Answers  

What are different types of raid configurations? : SQL Server Architecture

0 Answers  

In which files does sql server actually store data?

0 Answers  

what is trigger

1 Answers   CarrizalSoft Technologies, NIIT,

can any one post me, how to remove rows in the below table ENO ENAME EDEPT ELOC 3368 BPS BI Adayar 3371 RAN BI valachari 3369 SRI BI valachari 3372 jay BI Chn - - - - - - - -

2 Answers  




What is indexing a document?

0 Answers  

explain different types of jions with examples briefly?

2 Answers   Accenture, Excellence, Zensar,

What is the guest user account in sql server? What login is it mapped to it? : sql server security

0 Answers  

what is Covering Index ?

3 Answers   Thomson Reuters,

How do triggers work?

0 Answers  

What happens on checkpoint?

0 Answers  

What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories