SQL Server: How to get a subitem of sp_helplanguage ?

Posted by Quandary on Stack Overflow See other posts from Stack Overflow or by Quandary
Published on 2010-03-12T11:27:02Z Indexed on 2010/03/12 11:37 UTC
Read the original article Hit count: 238

Filed under:
|

Question: I can get the SQL Server database language by querying:

SELECT @@language 

And I can get further info via

EXEC sp_helplanguage

How can I query for a column of sp_helplanguage where name= @@language

I do SELECT * FROM sp_helplanguage WHERE name='DEUTSCH'

but that obviously doesn't work.

What's the correct way to query it ?

© Stack Overflow or respective owner

Related posts about sql

Related posts about sql-server