Lab Sql

I'm trying to read a CSV file from within a web application (Tomcat 5.5.x) and all I get is … Read more How To Access Csv File Within War Using H2's Csvread() Function/query?

How do I adapt the query below so that it doesn't perform unnecessary UNION ALL unless the SELE… Read more Abort Subsequent Union All Commands If Match Found [h2]

This is my table: CREATE TABLE IF NOT EXISTS NODE ( UUID VARCHAR NOT NULL, PARENT_UUID VA… Read more How To Sort Parents And All Siblings Using Cte For Adjacency List?

I am trying to use the sqlFile command of liquibase in my changelog. I have the following in my ya… Read more Liquibase's Sqlfile Command Being Ignored For Sql Server

I have also added another TMP2 and was not able to run the query... Could you please help me on thi… Read more Syntax Error In Sql Statement “with” Keyword Throwing Exception

I'm using JDBC, need to constantly check the database against changing values. What I have curr… Read more Infinite Loop Database Check

I am trying to build an SQL schema for a system where we have channels, each with an id, and one or… Read more Sql One-to-many

SQL Server 2008 apparently has filtered indices. What is the cleanest way to achieve the same in H2… Read more H2 Database: Unique Constraint Only Over Non-null Values? (filtered Index)

I want to make a single H2 column in a H2 database to have a other collation (case insensitive) the… Read more Does H2 Support A Collation Defintion For One Single Column?

I have developed java desktop application with the use of H2(Embedded). I just have basic knowledge… Read more On Duplicate Key Update Feature In H2

H2 1.4.191. DbUnit 2.5.1. How this can be fixed? Code and results for 3 cases: org.dbunit.dataset.… Read more Org.dbunit.dataset.nosuchtableexception, But Table Exists

I am writing an accounting system backed by an h2 database. The tree of accounts is stored in the … Read more Stored Procedure Returns An Array; How To Use In Sql?

After a lot of reading and experimentation, it seems like I want PRIMARY strength for searching, bu… Read more H2 Database Collation: What To Choose?

I have developed java desktop application with the use of H2(Embedded). I just have basic knowledge… Read more On Duplicate Key Update Feature In H2

I am writing an accounting system backed by an h2 database. The tree of accounts is stored in the … Read more Stored Procedure Returns An Array; How To Use In SQL?

This is my table: CREATE TABLE IF NOT EXISTS NODE ( UUID VARCHAR NOT NULL, PARENT_UUID VA… Read more How To Sort Parents And All Siblings Using CTE For Adjacency List?

I'm trying to run a sql script using H2's runscript. One of the table contains a longtext t… Read more Inserting A Long Text In H2 Database From An SQL Script

I'm trying to run a sql script using H2's runscript. One of the table contains a longtext t… Read more Inserting A Long Text In H2 Database From An SQL Script