best way to localize hard coded values in sql stored procedure!!


  • i want to localize a stored procedure where in i have some values hardcoded , i need to change these value based on locale .

    suppose if the stored procedure is this : select * from table1 where name = 'abcd';

    ,  'abcd' is hardcoded now i want this to be translated based on locale .

    Tuesday, April 24, 2018 10:40 AM

All replies

  • SQLServer doesnt have an inbuilt translator

    The only way you can achieve this is to store the value in the languages of your choice in your table and use the corresponding column in the query based on language/regional settings

    Please Mark This As Answer if it solved your issue
    Please Vote This As Helpful if it helps to solve your issue
    My Wiki User Page
    My MSDN Page
    My Personal Blog
    My Facebook Page

    Tuesday, April 24, 2018 10:58 AM