Aug 6, 2013

Sql script to get the current language of sql server


Sql query to get the current language of sql server

SELECT @@LANGUAGE AS [LanguageName]

Sample Output:

LanguageName
us_english

We can change the default language:

SET LANGUAGE 'us_english'

The select list for the INSERT statement contains more items than the insert list. The number of SELECT values must match the number of INSERT columns.


Suppose we have created a table tblOrder and inserted some data into it in sql server

CREATE TABLE tblOrder(
     OrderId INT PRIMARY KEY,
     OrderName VARCHAR(100)
)

INSERT tblOrder VALUES(1,'PC'),(2,'Laptop')

There is another table tblOrderHistory:

CREATE TABLE tblOrderHistory(
     OrderId INT,
     OrderName VARCHAR(100),
     HistoryDate DATETIME DEFAULT(GETDATE())
)

Now if we will execute following sql query:

INSERT INTO tblOrder(OrderId,OrderName)
SELECT * FROM tblOrderHistory

We will get error message like:

The select list for the INSERT statement contains more items than the insert list. The number of SELECT values must match the number of INSERT columns.

Cause: Select statement from tblOrderHistory selecting three columns while we are trying to insert into the only two columns. So it is syntax error.

Solution:

Correct syntax is:

INSERT INTO tblOrder(OrderId,OrderName)
SELECT OrderId,OrderName FROM tblOrderHistory