title: How to localize sql server data?
body: <p>We have a requirement to develope an application that support multiple languages (English, German, French, Russian) and we know, we can use ASP.NET localization to localize static text of a web form but what would be the approach for data localization of a database in SQL server.</p>
  
  <p>for example my database schema is something like this:</p>
  
  <p>Table-<strong>Questions</strong></p>
  
  <p>QID-PK</p>
  
  <p>Question</p>
  
  <p>CreatedBy</p>
  
  <p>Table- <strong>Answer</strong></p>
  
  <p>AID-PK</p>
  
  <p>QID- FK</p>
  
  <p>Answer</p>
  
  <p>AddedBy</p>
  
  <p>In the above schema,I want the column "question" from Question table and column "Answer" from Answer table should keep localization value.</p>
  
  <p>How do I achive this. </p>