In MongoDB, the $arrayToObject aggregation pipeline operator converts an array to a document.
Author: Ian
MongoDB $objectToArray
In MongoDB, the $objectToArray aggregation pipeline operator converts a document to an array.
MongoDB $not Aggregation Pipeline Operator
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.
MongoDB $mod
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.
Continue readingMongoDB $max Aggregation Pipeline Operator
In MongoDB, the $max aggregation pipeline operator returns the maximum value from an expression.
MongoDB $min Aggregation Pipeline Operator
In MongoDB, the $min aggregation pipeline operator returns the minimum value from an expression.
MongoDB $sum Aggregation Pipeline Operator
In MongoDB, the $sum aggregation pipeline operator calculates and returns the sum of numeric values.
MongoDB $avg Aggregation Pipeline Operator
In MongoDB, the $avg aggregation pipeline operator calculates and returns the average value of the specified numeric values.
How to Edit Linked Server Options using T-SQL
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.
MongoDB $substrBytes
In MongoDB, the $substrBytes aggregation pipeline operator returns the substring of a string, based on the specified UTF-8 encoded bytes indexes.