SQL Server supports various operators that allow you to perform operations on data and manipulate the result set. These operators can be used in SQL queries to filter, combine, and manipulate data. Here are some commonly used SQL Server operators: An operator is a symbol specifying an action that is performed on one or more […]
Category: MSSQL-2019
SQL Server Window Functions
SQL Server Window Functions are a powerful feature that allows you to perform calculations across a set of rows in a result set. These functions operate on a “window” of rows defined by a partition and an ordering, and they can provide aggregated results, rankings, row numbering, and more. SQL Server Window Functions calculate an […]
SQL Server Date Functions
SQL Server provides several date functions that allow you to work with date and time values. These functions help you retrieve, manipulate, and format dates and times in various ways. Here are some commonly used SQL Server date functions: Returning the current date and time Function Description CURREMT TIMESTAMP Returns the current system date and […]
SQL Server Mathematical functions
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 […]