Db2 supports the IDENTITY keyword to create autoincremental columns. Several options are available.
PostgreSQL: Change passwords
Let’s see how to change a user’s password or your own password in PostgreSQL. We’ll also discuss how to avoid sending the password in clear over a network.
MariaDB CRUD operations Hello World
Let’s see a slightly elaborated “Hello world”, to demonstrate the most common SQL operations with MariaDB: creating a database and a table, inserting a row, reading it, modifying it, deleting it.
SQL Server: Concatenate strings (NULL-safe)
There are several ways to concatenate strings in SQL, and they mainly differ in how they handle NULL values.
Creating UNSIGNED columns in SQL Server
Some DBMSs, like MariaDB and MySQL, allow to create UNSIGNED columns. SQL Server doesn’t support unsigned integers. Let’s see what we can do instead.
PostgreSQL: Tables without columns
PostgreSQL allows to create, read and write tables without columns. Let’s see how to work with them, and whether they can have practical uses.
Db2: Stored procedures examples in SQL
Simple examples of SQL stored procedures in Db2.
PostgreSQL: Check which privileges a user has on a table
Let’s see how to check what a user can do with a certain PostgreSQL table, or which users have a certain permission on a table.
MariaDB: Rollback the transaction if a warning occurs
In MariaDB most errors cause the current transaction to rollback, but warnings don’t. This article shows how to rollback when a warning happens.
SQL Server: Handle errors
SQL Server allows to handle errors with TRY ... CATCH blocks, and provides several statements to get information about the error that is being handled.