Tagged: sql

0

SysTools SQL Recovery

Repair Corrupt MDF & NDF SQL Server Database & Export into SQL Server Database The SysTools SQL Recovery tool, a versatile and useful solution to resolve the corruption issue of SQL database files (MDF) effectively. Get...

0

Relational to JSON With SQL

Oracle started adding JSON support to Oracle Database with version 12.1.0.2. The earliest support was targeted at storing, indexing, and querying JSON data. Version 12.2 rounded out that support by adding features for generating,...

0

SQL Server Error 18456: A Solution

Introduction In this article, we will explain how to fix the SQL Server Error 18456. We will first describe the error and then we will show different ways to solve this SQL Server error...

0

Code You Should Never See in PL/SQL

If you ever run across any of the following, apply the suggested cleanup or contact the owner of the code…or run for the hills. I am pretty sure many of my readers will have...

0

Fun With SQL: Functions in Postgres

In our previous Fun with SQL post on the Citus Data blog, we covered window functions. Window functions are a special class of function that allow you to grab values across rows and then perform some logic. By...