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

what are user defined datatypes? : Sql server database administration

0 Answers  

How can windows applications connect to sql servers via odbc?

0 Answers  

How can u get the number of pupils connecting the database?

1 Answers   Cap Gemini,

What action plan is preferred if sql server is not responding?

0 Answers  

what is IDE,DMV in sql server?

1 Answers   Value Labs,




What is the recovery model? List the types of recovery model available in sql server?

0 Answers  

what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration

0 Answers  

What do you understand by coalesce in sql server?

0 Answers  

What does Master database contains?

0 Answers   Abacus,

How do you send email on SQL Server?

0 Answers   MindCracker,

What is the stuff?

0 Answers  

What does set rowcount do?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories