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 […]
Category: MSSQL-2019
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 […]