In MongoDB, the $min aggregation pipeline operator returns the minimum value from an expression.
Category: DBMS
Database Management Systems
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.
MongoDB $substrCP
In MongoDB, the $substrCP aggregation pipeline operator returns the substring of a string, based on the specified UTF-8 code point indexes.
Get the Short Day Name in SQL Server (T-SQL)
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.
Continue readingMongoDB $strLenCP
MongoDB, the $strLenCP aggregation pipeline operator returns the number of UTF-8 code points in the specified string.
The $strLenCP operator is different to the $strLenBytes operator, which returns the number of bytes in the string.
MongoDB $strLenBytes
MongoDB, the $strLenBytes aggregation pipeline operator returns the number of UTF-8 encoded bytes in the specified string.
Each character in a string can contain contain a different number of bytes, depending on the character being used. The $strLenBytes operator can figure out how many bytes each character contains and return the correct result for the whole string.
MongoDB $stdDevPop
In MongoDB, the $stdDevPop aggregation pipeline operator calculates the population standard deviation of its input values.
The input values can be from a group of documents (i.e. documents that are grouped by the same key), or they can be multiple fields within a single document.
Continue reading