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.
How 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.
How RAND() Works in MariaDB
In MariaDB, RAND() is a built-in function that returns a random DOUBLE precision floating point value v in the range 0 <= v < 1.0.
How ACOS() Works in MariaDB
In MariaDB, ACOS() is a built-in numeric function that returns the arccosine (inverse cosine) of its argument.
In other words, it returns the value whose cosine is the argument.
3 Ways to Sort Documents in MongoDB
MongoDB provides a few ways to sort documents in a particular order. Each of these allow us to order the documents in ascending or descending order.
There’s also the option to order the results of a $text search – sorting by the computed textScore metadata in descending order.
Here are 3 ways to sort documents in MongoDB.
How POW() Works in MariaDB
In MariaDB, POW() is a built-in function that returns the value of its first argument raised to the power of its second argument.
How CONV() Works in MariaDB
In MariaDB, CONV() is a built-in numeric function that converts numbers between different number bases. For example, you can use it to convert a number from base 10 to base 16.
It returns a string representation of the converted number.
Replace a String with another String in SQL Server (T-SQL)
In SQL Server you can use the REPLACE() function to replace all occurrences of a string with another string.
The function accepts three arguments; the string that contains the string to be replaced, the string to be replaced, and the string to replace it.