If you need to return the size of a document in MongoDB, you can use the following:
- The
$bsonSizeaggregation pipeline operator - The
Object.bsonSize()method
Below are examples of each approach.
Continue readingCategory: DBMS
Database Management Systems
How LOG10() Works in MariaDB
In MariaDB, LOG10() is a built-in function that returns the base-10 logarithm of its argument.
How LOG2() Works in MariaDB
In MariaDB, LOG2() is a built-in function that returns the base-2 logarithm of its argument.
How TRUNCATE() Works in MariaDB
In MariaDB, TRUNCATE() is a built-in numeric function that returns a given number, truncated to a given number of decimal places.
How DIV Works in MariaDB
In MariaDB, DIV performs integer division.
It discards from the division result any fractional part to the right of the decimal point.
Continue readingHow ABS() Works in MariaDB
In MariaDB, ABS() is a built-in numeric function that returns the absolute (non-negative) value of its argument.
8 Ways to Add Microseconds to a Datetime Value in MariaDB
If you need to add one or more microseconds to a datetime value in MariaDB, here are 8 options to consider.
Continue readingHow ROUND() Works in MariaDB
In MariaDB, ROUND() is a built-in numeric function that rounds its argument to a given number of decimal places.
How ASIN() Works in MariaDB
In MariaDB, ASIN() is a built-in numeric function that returns the arcsine (inverse sine) of its argument.
In other words, it returns the value whose sine is the argument.
Continue readingHow to do an INSERT Pass-Through Query in SQL Server
In SQL Server, you can use OPENQUERY to execute a pass-through query on a linked server.
OPENQUERY is commonly referenced in the FROM clause of a query as if it were a table, but it can also be referenced as the target table of an INSERT, UPDATE, or DELETE statement.
This article presents an example of using OPENQUERY to do an INSERT pass-through query.