Database.Guide – Page 194

5 Ways to Return Rows that Contain Lowercase Letters in SQL Server

January 14, 2022 by Ian

If you need to find rows that contain lowercase letters in SQL Server, you could try one of the following options.

How to Show the Current Setting for Null Output in PostgreSQL (psql)

January 14, 2022 by Ian

When using psql, null values are returned as an empty string by default.

This can easily be changed with the \pset command, so it could be a value other than the default empty string.

If you’re not sure what your current value is, you can use the show \pset null command to show the current value.

Formatting Numbers with Commas in MariaDB

January 13, 2022 by Ian

In MariaDB, we can use the FORMAT() function to format a number with commas.

More specifically, the function returns the number as a formatted string, with thousands separators and a decimal separator, and rounded to the given decimal position.

Fix Msg 241 “Conversion failed when converting date and/or time from character string” in SQL Server

January 18, 2023January 13, 2022 by Ian

If you’re getting SQL Server error Msg 241 that reads Conversion failed when converting date and/or time from character string, it’s probably because you’re trying to convert a string to a date/time value, but that particular string can’t be converted to the date/time type specified.

2 Ways to Create a Table if it Doesn’t Exist in SQL Server

January 6, 2023January 12, 2022 by Ian

T-SQL doesn’t include the IF NOT EXISTS clause with its CREATE TABLE statement, like some other DBMSs do.

Therefore, if we want to check for the existence of the table before we create it in SQL Server, we need to use other methods.

Find Values That Don’t Contain Numbers in SQLite

January 12, 2022 by Ian

The following example returns all rows that don’t contain any numbers in SQLite.

By “number” I mean “numerical digit”. Numbers can also be represented by words and other symbols, but for the purpose of this article, we’re returning values that don’t contain any numerical digits.

How to Subtract a Day from a Date in MariaDB

January 11, 2022 by Ian

MariaDB provides several ways to perform arithmetic on dates. This includes adding or subtracting a day (or many days) from a given date.

Here’s an example of subtracting a day from a date in MariaDB.

List All Functions in Oracle Database

January 11, 2022 by Ian

Here are several ways to get a list of functions in Oracle Database.

Add the Ordinal Indicator to a Date in Oracle

January 10, 2022 by Ian

In Oracle Database, we can use the TH format element to add the ordinal number suffix to the result of a TO_CHAR() operation when formatting dates.

For example, instead of outputting 10 Feb we could output 10th Feb. Or, instead of outputting 21 century, we can output 21st century. The same applies for spelled date components. For example, instead of Twenty One, we can output Twenty First.

3 Ways to Get the Collations Available in MariaDB

January 10, 2022 by Ian

If you need to find the collations that are available in your MariaDB installation, check out the following three methods.