MongoDB $filter

In MongoDB, the $filter aggregation pipeline operator returns a subset of an array based on a specified condition.

The $filter operator returns an array with only those elements that match the condition, in their original order.

Read more

How to Fix “Procedure expects parameter ‘@statement’ of type ‘ntext/nchar/nvarchar’.” Error in SQL Server

It’s quite easy to encounter error Msg 214, Level 16 when executing stored procedures such as sp_executesql or sp_describe_first_result_set.

Fortunately it’s easy to fix too!

The most common reason for getting this error is that you forgot to prefix your string with N.

Therefore, to fix this issue, try prefixing your string with N.

Read more

MongoDB $exp

In MongoDB, the $exp aggregation pipeline operator raises Euler’s number (i.e. e ) to the specified exponent and returns the result.

The exponent can be any valid expression that resolves to a number.

Read more

MongoDB $tanh

In MongoDB, the $tanh aggregation pipeline operator returns the hyperbolic tangent of a value that is measured in radians.

$tanh accepts any valid expression that resolves to a number.

The $tanh operator was introduced in MongoDB 4.2.

Read more

MongoDB $cond

In MongoDB, the $cond aggregation pipeline operator evaluates a boolean expression, and returns one of the two specified return expressions, depending on whether the boolean expression is true or false.

The $cond operator accepts two syntaxes: a longhand syntax and a shorthand syntax. Examples of each are below.

Read more

MongoDB $cmp

In MongoDB, the $cmp aggregation pipeline operator compares two values and returns either -1, 1, or 0, depending on whether the first value is less than, greater than, or equal to the first value.

Read more