Microsoft SQL Server

SQL Server Tutorial, Query's and Interview Questions

Thursday, 20 July 2017

Get Current Language of SQL Server

Get Current Language of SQL Server

Select @@LANGUAGE as Language

Posted by Unknown at 23:01

Email This BlogThis!Share to X Share to Facebook Share to Pinterest

No comments:

Post a Comment

Older Post Home

Subscribe to: Post Comments (Atom)

About Me

Unknown

View my complete profile

Labels

Adding a Column to a Table in SQL Server (1)
Basic functions for master msdb model tempdb and resource databases? (1)
Benefits of Stored Procedures (1)
Commands for rename a db a table and a column? (1)
Create a Stored Procedure (1)
Difference between COALESCE() & ISNULL() ? (1)
Difference between DateTime and DateTime2 DataType (1)
Difference Between Sql Server VARCHAR and NVARCHAR Data Type (1)
Difference between Stored Procedures and Functions (1)
Difference between Stored Procedures and Views (1)
Different ways to replace NULL in SQL SERVER (1)
Executing a Stored Procedure (1)
Generate file or text output from SQL Server? (1)
How many Days in a year by SQL Query (1)
How to convert varchar data type column to int in SQL Server while querying? (1)
How to copy data from one table to another table.? (1)
How to delete duplicate values by using CTE expressions.? (1)
How to display all days in a month by SQL Server? (1)
How to enable mixed authentication in SQL server? (1)
How to find the current and system users in SQL Server by SQL query? (1)
How to get most recently Row inserted in a table? (1)
How to get date of 5 days back in SQL Server? (1)
How to list all the tables in SQL Server for particular Schema.? (1)
How to restore the sample database(.bak file) in SQL Server? (1)
How to restrict the stored procedure naming convention in SQL server. (1)
How to return XML in SQL Server.? (1)
How to Swap the values of two columns in SQL Server (1)
In which Files does SQL Server Actually Store Data? (1)
Insert Multiple Records Using One Insert Statement (1)
Insert/Select multiple records using one Insert/Select Statement (1)
List all schema names by SQL query? (1)
List all schema names with table by SQL query? (1)
List all table names of a particular database by SQL query? (1)
List all table names user created tables by SQL Query? (2)
List all the stored procedures User created by SQL query.? (1)
List of database users and server level users in SQL Server ? (1)
Maximum Capacity Specifications for SQL Server(Table Column Users etc) (1)
Modifying a Stored Procedure (1)
Salary Related Queries (1)
Shadow Copy In SQL Server Without Using Create Command (1)
SQL SERVER – Stored Procedure to display text of Stored Procedure Trigger View. (1)
SQL Server Aggregate Functions (1)
SQL Server Basic Queries (1)
SQL Server BETWEEN Operator (1)
SQL Server CAST() and CONVERT() functions (1)
SQL Server COALESCE function (1)
SQL Server Commands (1)
SQL Server Constraints (1)
SQL Server CTE (1)
SQL Server Cursor functions (1)
SQL Server Date Time Functions (1)
SQL Server DATEADD and DATEDIFF functions (1)
SQL Server DISTINCT function (1)
SQL Server Group By (1)
SQL Server Having Clause (1)
SQL Server IN Operator (1)
SQL Server ISNULL() function (1)
SQL Server Joins (1)
SQL Server LIKE Operator and WildCards (1)
SQL Server Local and Global Variables (1)
SQL Server Mathematical Functions (1)
SQL Server NULL (1)
SQL Server NULLIF function (1)
SQL Server PRINT Keyword (1)
SQL Server Schema (1)
SQL Server Select Clause (1)
SQL Server Stored Procedure (1)
SQL Server String (1)
SQL Server String Functions (1)
SQL Server Subquery (1)
SQL Server TOP Keyword (1)
SQL Server TOP WITH TIES (1)
SQL Server Triggers (1)
SQL Server Truncate and Delete (1)
SQL Server Union and Union All (1)
SQL Server USE Keyword (1)
SQL Server Version by SQL query? (1)
SQL Server WHERE Clause (1)
SQL statement processing order (1)
Stored Procedures Optimization Tips (1)
String Functions – Count Words (1)
Structure of the table (1)
Ten Common SQL Programming Mistakes (1)
Three ways to get an accurate count of the number of records in a table? (1)
Tips to improve SQL Server database design and performance (1)
To View a Stored Procedure (1)
Using @@ROWCOUNT (1)
Using CASE with ORDER BY in SQL Server (1)
Using try catch in SQL Server stored procedures with example (1)
When we should use inner join and sub query? (1)
Where SQL server user names and passwords are stored in SQL server? (1)
Which are new data types introduced in SQL SERVER 2008? (1)

Categories

Adding a Column to a Table in SQL Server (1)
Basic functions for master msdb model tempdb and resource databases? (1)
Benefits of Stored Procedures (1)
Commands for rename a db a table and a column? (1)
Create a Stored Procedure (1)
Difference between COALESCE() & ISNULL() ? (1)
Difference between DateTime and DateTime2 DataType (1)
Difference Between Sql Server VARCHAR and NVARCHAR Data Type (1)
Difference between Stored Procedures and Functions (1)
Difference between Stored Procedures and Views (1)
Different ways to replace NULL in SQL SERVER (1)
Executing a Stored Procedure (1)
Generate file or text output from SQL Server? (1)
How many Days in a year by SQL Query (1)
How to convert varchar data type column to int in SQL Server while querying? (1)
How to copy data from one table to another table.? (1)
How to delete duplicate values by using CTE expressions.? (1)
How to display all days in a month by SQL Server? (1)
How to enable mixed authentication in SQL server? (1)
How to find the current and system users in SQL Server by SQL query? (1)
How to get most recently Row inserted in a table? (1)
How to get date of 5 days back in SQL Server? (1)
How to list all the tables in SQL Server for particular Schema.? (1)
How to restore the sample database(.bak file) in SQL Server? (1)
How to restrict the stored procedure naming convention in SQL server. (1)
How to return XML in SQL Server.? (1)
How to Swap the values of two columns in SQL Server (1)
In which Files does SQL Server Actually Store Data? (1)
Insert Multiple Records Using One Insert Statement (1)
Insert/Select multiple records using one Insert/Select Statement (1)
List all schema names by SQL query? (1)
List all schema names with table by SQL query? (1)
List all table names of a particular database by SQL query? (1)
List all table names user created tables by SQL Query? (2)
List all the stored procedures User created by SQL query.? (1)
List of database users and server level users in SQL Server ? (1)
Maximum Capacity Specifications for SQL Server(Table Column Users etc) (1)
Modifying a Stored Procedure (1)
Salary Related Queries (1)
Shadow Copy In SQL Server Without Using Create Command (1)
SQL SERVER – Stored Procedure to display text of Stored Procedure Trigger View. (1)
SQL Server Aggregate Functions (1)
SQL Server Basic Queries (1)
SQL Server BETWEEN Operator (1)
SQL Server CAST() and CONVERT() functions (1)
SQL Server COALESCE function (1)
SQL Server Commands (1)
SQL Server Constraints (1)
SQL Server CTE (1)
SQL Server Cursor functions (1)
SQL Server Date Time Functions (1)
SQL Server DATEADD and DATEDIFF functions (1)
SQL Server DISTINCT function (1)
SQL Server Group By (1)
SQL Server Having Clause (1)
SQL Server IN Operator (1)
SQL Server ISNULL() function (1)
SQL Server Joins (1)
SQL Server LIKE Operator and WildCards (1)
SQL Server Local and Global Variables (1)
SQL Server Mathematical Functions (1)
SQL Server NULL (1)
SQL Server NULLIF function (1)
SQL Server PRINT Keyword (1)
SQL Server Schema (1)
SQL Server Select Clause (1)
SQL Server Stored Procedure (1)
SQL Server String (1)
SQL Server String Functions (1)
SQL Server Subquery (1)
SQL Server TOP Keyword (1)
SQL Server TOP WITH TIES (1)
SQL Server Triggers (1)
SQL Server Truncate and Delete (1)
SQL Server Union and Union All (1)
SQL Server USE Keyword (1)
SQL Server Version by SQL query? (1)
SQL Server WHERE Clause (1)
SQL statement processing order (1)
Stored Procedures Optimization Tips (1)
String Functions – Count Words (1)
Structure of the table (1)
Ten Common SQL Programming Mistakes (1)
Three ways to get an accurate count of the number of records in a table? (1)
Tips to improve SQL Server database design and performance (1)
To View a Stored Procedure (1)
Using @@ROWCOUNT (1)
Using CASE with ORDER BY in SQL Server (1)
Using try catch in SQL Server stored procedures with example (1)
When we should use inner join and sub query? (1)
Where SQL server user names and passwords are stored in SQL server? (1)
Which are new data types introduced in SQL SERVER 2008? (1)

Text Widget

Blog Archive

▼ 2017 (1)
- ▼ July (1)
  - Get Current Language of SQL Server

► 2015 (93)
- ► October (3)
- ► September (5)
- ► August (1)
- ► July (5)
- ► June (2)
- ► May (11)
- ► April (48)
- ► March (18)

Our sponsors

Recent Posts

Pages

Home

Popular Posts

SQL Server Basic Queries

SQL Server Basic Queries : 1.Display all the information of the EMP table? A) select * from emp ; 2.Display unique Jobs from E...
SQL Server COALESCE function

COALESCE : COALESCE function in SQL returns the first non-NULL expression among its arguments. Syntax for COALESCE is as follows: CO...
SQL Server: TOP WITH TIES

SQL Server: TOP WITH TIES TOP clause is commonly used to get top required rows from a result set. Beauty of this clause is that it can...
Create a Stored Procedure

Create a Stored Procedure To create a stored procedure, you need to use the CREATE PROCEDURE statement, followed by the code that mak...
Using @@ROWCOUNT ( System Variable)

Using @@ROWCOUNT ( System Variable) @@ROWCOUNT : It is a very useful system variable that returns the number of rows read/affected by...
SQL SERVER – Stored Procedure to display code (text) of Stored Procedure, Trigger, View.

SQL SERVER – Stored Procedure to display code (text) of Stored Procedure, Trigger, View. System stored procedure that prints the text ...
Get Current Language of SQL Server

Get Current Language of SQL Server Select @@LANGUAGE as Language
Modifying a Stored Procedure

Modifying a Stored Procedure If you need to modify an existing stored procedure, simply replace the CREATE with ALTER. Let's add a...
Difference between Stored Procedures and Views

Difference between Stored Procedures and Views Stored Procedures Views Does not accepts parameters ...
Execute a Stored Procedure

Executing a Stored Procedure Now that if you've created your stored procedure, any time you want to execute it, you need to call i...

Text Widget

Total Pageviews

Simple theme. Powered by Blogger.