Welcome -
Guest!
Login
/
Register Now
|
Search:
Home
Articles
Forum
Interview FAQ
Activities
News
Videos
Poll
Links
People
Groups
SQL Server Articles
Submit Article
Home
»
Articles
»
SQL Server
»
Configuration Functions
RSS Feeds
@@LANGUAGE - LANGUAGE Function
Posted By:
Sarita Patel
Category:
SQL Server
Views:
2009
This article explains about @@LANGUAGE function in sql server with examples.
@@LANGUAGE function is used to get name of the language in use. You can view information of language settings by running
sp_helplanguage
without any parameters.
Syntax of @@LANGUAGE Function :
@@LANGUAGE
Return type
of @@LANGUAGE function is nvarchar.
Examples of @@LANGUAGE Function :
Example 1 : Use of @@LANGUAGE function in select clause
SELECT
@@LANGUAGE
Output
us_english
Above example returns current language in use for current session.
Share:
Previous Post:
@@SERVERNAME - SERVERNAME Function
Next Post:
@@SERVICENAME - SERVICENAME Function
Didn't find what you were looking for? Find more on
@@LANGUAGE - LANGUAGE Function
Or get
search suggestion and latest updates
.
Sarita Patel
author of @@LANGUAGE - LANGUAGE Function is from
United States
.
View All Articles
Related Articles and Code:
An Assembly Language Program to check for Palindrome string
An Assembly Language Program sort a given series in ascending order
An Assembly Language Program to find 2's Complement of given binary number
Basic C Programming Language
Program of nesting member functions, private member functions and array of objects
Example 4 of using function and local variables in functions
Program which creates an Array of character. Make one function with one argument as a character and that function throw a user defined exception
Program to read numbers from two files using fscanf function and write it in another file using fprintf function in ascending order
Write a function to perform string operation i.e. split, join, length, substring using pointer without using any string function
FUNCTION XSTRCHR() WHICH SCANS A STRING FROM START TO END IN SEARCH OF A CHARACTER
Display student details born in year 1980 to 1982 using to_char() function
Program to read string using gets() function and display in upper case
User Defined Functions
Function
String functions
To show the use of stack in function calls
Write a query to add days in todays date using sysdate function
Write a query to add and subtract months using add_months function
Write a query to change the format of date using to_char function
Write a query to change the case of strings using lower and upper function
Other Interesting Articles in SQL Server:
FLOOR Function
Meta Data Functions
PATINDEX Function
FULLTEXTCATALOGPROPERTY Function
CONTAINSTABLE Function
Sorting Rows with ORDER BY
OBJECT_NAME Function
Examples of * ( Multiply ) Operator
Operators Allowed in the WHERE Clause with examples
> ( Greater Than ) Comparison Operator
FILEPROPERTY Function
HOST_NAME Function
COL_NAME Function
SQRT Function
STDEVP Function
ASCII Function
CURRENT_USER Function
ISNULL Function
SUSER_SID Function
DAY Function
Please enter your Comment
*
*
Comment should be atleast 30 Characters.
Please put code inside [Code] your code [/Code].
Please login to post comment
No Comment Found, Be the First to post comment!
SQL Server
View All
Aggregate Functions
Analytical Functions
Configuration Function...
Constraints
Cursor
Cursor Functions
Data Control Language
Data Definition Lang
Data Manipulation Lang
Data Type
Database
Date Time Functions
Functions
Index
Interview FAQ
Joins
Math Functions
Meta Data Functions
Miscellaneous
Operator
Rowset Functions
Security Functions
Select Query
Sequence
Stored Procedures
String Functions
Sub Query
System Functions
System Statistical Fun...
Text and Image Functio...
Transaction Control La...
Trigger
View
Assembly Language
Artificial Intelligence
C Programming
C++ Programming
Visual C++
OOAD
Cobol
Java
Asp.net MVC
Rest and WCF Services
Entity Framework
Knockout.Js
Unix / Linux / Ubuntu
Networking
OOPs Concept
HTML
Dos
SQL
System Analysis & Design
Gadgets
Internet
CSS
Javascript
.Net Framework
Asp.net
C#
VB.Net
Python
Perl
Oracle
Software Engineering
RDBMS Terms
AJAX Framework
Design Pattern
UML
WPF
WCF
SEO
PowerShell
Visual Studio
WWF
BizTalk Server
Azure
General
Testing
Online Certifications
PHP
My SQL
LinQ
Project Management
Silverlight
XML
MS Office
Windows OS
DHTML
Sharepoint