The error message “Conversion failed when converting the varchar value to data type int” occurs in SQL Server when attempting to convert a value stored as the varchar (text)...
SUBSTRING function is used in sql to select part of text string in text. This function belongs to the group of text functions – string functions. I created a...
SQL COUNT function belongs to Aggregate functions and it is one of the most easy-to-use and also most used functions of SQL. It enables user to count rows in...
REPLACE function is used to replace text string or its parts. It belongs to the category of string functions. I created big overview of T-SQL text functions some time...
ISNULL and COALESCE are functions used for work with null values (NULL). Both functions return first value out of previously defined entry parameters. There are also some differences between...
T-SQL is not a language designed primarily to do something big with text strings or manipulate with them. That is the reason why we will not find many text-related...
SQL aggregate functions AVG, COUNT, MAX, MIN, SUM are used the most. That is because we often need to add, make average or find the highest or lowest value....
SQL ranking functions enable us to rank records in the table based on values of a field or multiple fields. Clause OVER() is mandatory for the ranking functions. Ranking...
OFFSET functions are relatively new to MS SQL Server. They are available since SQL Server 2012 version. These functions enable a user to “list” through rows of a table....