In MongoDB, the $not aggregation pipeline operator evaluates a boolean and returns the opposite boolean value.
In other words, when the boolean evaluates to true, the $not operator returns false. And when the boolean evaluates to false, the $not operator returns true.
In MongoDB, the $mod aggregation pipeline operator divides one number by another and returns the remainder.
To use $mod, pass the two numbers in an array. The $mod operator will divide the first number by the second number and return the remainder. In other words, the first number is the dividend, and the second number is the divisor.
The arguments can be any valid expression as long as they resolve to numbers.
In MongoDB, the $max aggregation pipeline operator returns the maximum value from an expression.
In MongoDB, the $min aggregation pipeline operator returns the minimum value from an expression.
In MongoDB, the $sum aggregation pipeline operator calculates and returns the sum of numeric values.
In MongoDB, the $avg aggregation pipeline operator calculates and returns the average value of the specified numeric values.
If you’ve previously created a linked server, but you now want to update one or more of its server options, you can do that either via the SQL Server Management Studio GUI or with T-SQL.
If you choose to do it with T-SQL, the sp_serveroption system stored procedure is what you need.
In MongoDB, the $substrBytes aggregation pipeline operator returns the substring of a string, based on the specified UTF-8 encoded bytes indexes.
In MongoDB, the $substrCP aggregation pipeline operator returns the substring of a string, based on the specified UTF-8 code point indexes.
In SQL Server, you can use the FORMAT() function to return the short day name from a date. FORMAT() is a T-SQL function that enables you to format dates and numbers to a specified format.
This function returns its result as a string. Specifically, it returns it as either a nvarchar or null as the case may be.