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


Top 5 Contributors of the Month
david stephan

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
hello.
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

Responses
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
JavaScript/VBScriptBiztalkWPFPatten/PracticesWCFOthers
www.DotNetSpark.comUnAnsweredAll

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