You can get the language ID with the following Select statement:
SET LANGUAGE 'French' SELECT @@LANGID AS 'Language ID'
Visit the DevX Tip Bank