SQL Server

In this tutorial, learn how to work with different languages in SQL Server. Learn how to change SQL server language settings. Find out the language list that SQL server supports along with the language codes & language id etc. We also lean how to change the language settings in case of contained database.

The format function in SQL Server allows us to display the date in various formats. The SQL Server stores the date & time as integers. But in real worlds the date & time format that people use change from culture to culture. For Example some display the date as DD/MM/YYYY while some as YYYY/MM/DD. Hence it is important to format the date & time as per the users preference before displaying it to the user.

Time is the SQL Server data type that we use to store Time. It stores the time of a day, without time zone and using 24 hours format. It stores only the time without the date part.

SQL Server money data types are special data types that represent monetary or currency values. SQL Server comes with two variants of the money data type. One is smallmoney and the other one is money

nchar & nvarchar (nvarchar(max)) are the Unicode string data types in SQL Server. They are similar to char & varchar but stores the strings in Unicode encoding. nchar is a fixed width data type while nvarchar is a variable-length data Type. In this tutorial, we will learn what is nchar & nvarchar data types, and how to use them. Also, learn similarities and differences between them.