SQL Injection (SQLi) is a type of security vulnerability that allows an attacker to interfere with the queries that an application makes to its database. SQL Injection is one of the most common and ...

With the official release of Microsoft's latest database offering, let's see what was improved and what still needs some work. Today, at Ignite, Microsoft announced the general availability of SQL ...

Starting with versions 7.4 TR3 and 7.3 TR9, DB2 for IBM i provides the ability to directly read and write IFS files. Here, we will look at some examples of how to read IFS files using "pure" SQL or ...

Using a variable within an IN clause in SQL Server can be done in several ways depending on the context and what kind of data you are working with. Below are different methods to achieve this. Let's ...

pre-commit is a nice development tool to automatize the binding of pre-commit hooks. After installation and configuration pre-commit will run your hooks before you commit any change. CREATE OR REPLACE ...

If you ever need to sort character strings stored in SQL Server fields, check out this demonstration of how to write a common sorting algorithm using SQL Server TSQL code. You are probably familiar ...