SERVERPROPERTY is a system function in SQL Server that returns property details about the server instance, including the build version, collation, server name, instance name,
Tag: SQL Server built-in Functions
DATEDIFF_BIG Function in SQL Server
This function returns the number of times the specified date part boundaries were crossed between the supplied dates (as a signed big integer value). The
String and Arithmetic Expressions in SQL Server
The intention of this post is to explain the regularly used string and arithmetic expressions. CHARINDEX: This function searches for a substring in a string,
SQL Server String Functions-6
A string function accepts a string value as an input and returns a string value regardless of the data type. They’re used to convert an
SQL Server String Functions-5
A string function accepts a string value as an input and returns a string value regardless of the data type. They’re used to convert an
CHOOSE Function in SQL Server
In SQL Server, the CHOOSE function returns the item at the provided index from a list of values. CHOOSE is an index into an array,
Big Data & SQL 