In SQL Server, the CONVERT() function converts an expression of one data type to another.
Here’s a quick overview of the function with examples.
Continue reading3 Ways to Check a Column’s Data Type in PostgreSQL
Here are three ways to get the data type of a given column in MariaDB.
Continue readingHow CAST() Works in SQL Server
In SQL Server, the CAST() function converts an expression of one data type to another.
Here’s a quick overview of the function with examples.
Continue readingData Type Precedence in SQL Server
Below is a list containing the SQL Server data types, in order of precedence.
Continue readingHow to List all Stored Procedures in MariaDB
In MariaDB, we can use the SHOW PROCEDURE STATUS command to return a list of stored procedures.
We can also query the information_schema.routines table to do the same thing.
3 Ways to Check Column Data Type in Oracle
Here are three ways to get information about a table’s columns in Oracle, including their data types.
Continue reading4 Ways to Check a Column’s Data Type in MySQL
Here are four ways to get the data type of a column in MySQL.
Continue readingReturn Random Rows from a Table in MariaDB
Here’s a quick way to return random rows from a table in MariaDB.
Continue readingMAX() Function in PostgreSQL
In PostgreSQL, the MAX() function computes the maximum of the non-null input values and returns the result.
This function can be used on any numeric, string, date/time, or enum type, as well as inet, interval, money, oid, pg_lsn, tid, and arrays of any of these types.
MIN() Function in PostgreSQL
In PostgreSQL, the MIN() function computes the minimum of the non-null input values and returns the result.
This function can be used on any numeric, string, date/time, or enum type, as well as inet, interval, money, oid, pg_lsn, tid, and arrays of any of these types.