.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Sandeep Singh
Melody Anderson
Eminent IT

Home >> Forum >> Sql Server >> Post New QuestionBookmark and Share Subscribe to Forum

Table Translation records

Posted By: Aamrapali Tamgadge     Posted Date: April 28, 2014    Points:5   Category :Sql Server
I am having one scenario is like ..i have about 150 tables from that 150 table these tables are present in master database as well as their respective countries database.
For ex:one Category table is present in Master database and Category table is also in China Database.
but the English values are in Master and china values are in china database.
So i want to retrive Category name English values and CategoryName Translated values ....likewise for 150 tables in single query. how can i do this Please reply me its argent

Author: Akhil Raj       [Moderator]      
Posted Date: May 19, 2014     Points: 20   

If i understand correctly, you have same tables in different databases. You need to get all the data in one select query. Ami i right? You can select from databasename.tablename. Use dynamic sp to concatenate all the tables

Post Reply

You must Sign In To post reply
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more Here
Quick Links For Forum Categories:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  OOPs  SilverlightIISJQuery

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend