SQL Server provides several mathematical functions that allow you to perform mathematical calculations on numeric data. These functions operate on numeric values and return a single result. Here are some commonly used SQL Server mathematical functions: Function Name Descriptions ABS The function is used to get the absolute value or absolute positive value ACOS This […]
SQL Server Aggregate Functions
SQL Server provides a set of aggregate functions that allow you to perform calculations on a set of values and return a single result. These functions operate on a group of rows and return a single value based on the specified column or expression. Here are some commonly used SQL Server aggregate functions: Aggregate function […]
SQL Server String Functions
SQL Server provides a variety of string functions that allow you to manipulate and work with character or text data. Here are some commonly used SQL Server string functions: Function Description ASCII Return the ASCII code value of a character CHAR Convert an ASCII value to a character CHARINDEX Search for a substring inside a […]
SQL Server System Functions
SQL Server System Functions are built-in functions provided by Microsoft SQL Server that perform various tasks related to system information, data type conversion, string manipulation, date and time operations, mathematical calculations, and more. These functions are available for use within SQL queries and can help simplify and enhance the functionality of your database applications. Here […]