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
Category: SQL Server 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
STUFF Function in SQL Server
The STUFF function combines two strings into one. It deletes a specified number of characters from the beginning of the first string, then inserts the
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
IDENTITY usage in SELECT INTO – SQL Server
The IDENTITY function can be defined for an identity column when the table is created and for a new column when the table is altered.
Big Data & SQL 