The Log4jdbc Spring Boot 2+ Starter facilitates the quick and easy use of log4jdbc in Spring Boot projects. Log4jdbc is particularly handy as it can log SQL that is ready to run. Instead of logging ...

Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement. It’s sometimes difficult to know which SQL syntax to use when ...

It is not uncommon that a single SQL statement such as a SELECT statement includes sub-SQL SELECT statements, or sub-queries, that generate a sub-result set within the top-level statement. If these ...

SQL is neither the fastest nor the most elegant way to talk to databases, but it is the best way we have. Here’s why Today, Structured Query Language is the standard means of manipulating and querying ...

In SQL we support non-standard clause called ON CONFLICT / OR. It is not a separate clause which can appear in INSERT/UPDATE statements or as a column option in CREATE TABLE statements. See examples ...

Your browser does not support the audio element. I’ve always been fascinated by what can be achieved in terms of HTML and JavaScript in the browser. The amazing ...

Microsoft calls SQL Server 2016 the “biggest leap forward” in the 27-year evolution of the SQL Server database. As we’ll see, despite the excess of hype, the SQL Server 2016 database offers ...

Entity Framework 6 gives you a variety of ways to call stored procedures that return data and capture the results those procedures return. Here's a look at all of them. In an earlier column, I showed ...