Home Forums SQL Server 2012 SQL 2012 - General Sending emails to customers in their language RE: Sending emails to customers in their language

  • February 5, 2018 at 12:32 pm

    #1978613

    OlyKLin - Monday, February 5, 2018 11:44 AM

    Hi John

    This is what I tried:

    DECLARE @TEXT varchar(50)
    SELECT @TEXT = 'HELLO'

    SET LANGUAGE 'Spanish'
    SELECT @TEXT

    It just gives me back 'HELLO'.

    I thought about storing the messages in a text and just pulling them but I was hoping I might be able to do it on the fly

    SET LANGUAGE works on system messages and data formats but won't translate other text. With system messages, it gets the alternative language value from sys.messages. Storing that text may be something you want to do, similar to sys.messages, but it depends on how much text it involves. 

    Sue