The EOMONTH() function is one of the most commonly used functions in reporting and data analysis. For a given date, it returns the month’s last
Tag: SQL Server built-in Functions
Conditional Function IIF – SQL Server
Depending on whether the Boolean expression in SQL Server evaluates to true or false, the conditional function IIF returns one of two values. For ease
SQL Server Mathematical Functions-2
SQL Server’s mathematical functions assist in calculating values. The functions will assist with fundamental addition, subtraction, multiplication, and division, among other things. Let’s take a
SQL Server Mathematical Functions-1
SQL Server’s mathematical functions assist in calculating values. The functions will assist with fundamental addition, subtraction, multiplication, and division, among other things. Let’s take a
SQL Server Mathematical Functions-2
For the previous post, click here. As stated earlier, mathematical Functions are built-in scalar functions that perform calculations depending on input values provided as arguments
DIFFERENCE function in SQL Server
The DIFFERENCE() function returns an integer after comparing two SOUNDEX values. The integer number, ranging from 0 to 4, indicates the match between the two
Big Data & SQL 