LOB string splitter with ordinals in SQL Server 20169

sql-server-2016

Paul WhitePaul White

11This inline TVF converts the input string to JSON array format, then uses default `OPENJSON`.

Paul White

SQLITE SUM of timestamp values

sqlite

DeFactoDeFacto

0Your fiddle was from 3.27, Since that some date/time function got improved

Luuk

How to check active IDs from six months ago3

db2

SamSam

0Here is a single statement that achieves the desired result of `2` for the date of `2023-06-01` in the given data sample:

Andriy M

Do triggers work on dbfiddle with MySQL 5.6?7

dbfiddlemysql-5.6

VéraceVérace

2Triggers work, but the `DELIMITER` statement does not. It [isn't supported](https://stackoverflow.com/q/5311141/12757754) by the PHP driver, because it is not a mysql database command, but [mysql *client* command](https://dev.mysql.com/doc/refman/8.0/en/mysql-commands.html).

Jack Douglas

Need help handling NULLs in PostgreSQL1

postgresql-15

Evan845Evan845

3Well, that's a NULL _value_ not the the string `'null'`. You need to just set the value to an empty string. Calling `replace()` on a NULL value, won't change anything. The replace() on the string `null` doesn't really make sense either. You can combine both conditions:

Truilus

How to implement a relationship between 2 tables where the type of participation is mandatory and RESTRICT rule for both?

postgresql

torarittetoraritte

Cumulative SUM1

sqlite

DeFactoDeFacto

4The easiest way to achieve what you are trying to do would be to change your `ORDER BY Col1` to something like this:

Andriy M

Replace some results with NULL in SQlite10

sqlite

DeFactoDeFacto

4Yes, it's easy to do this with the [`case` expression](https://www.sqlite.org/lang_expr.html#the_case_expression)

Jack Douglas

Why isn't an Index Only Scan used on a partition accessed via the parent table?1

postgresql-14

Jack DouglasJack Douglas

3Well, you ask it to check `part_id`, don't you, and it's not a part of your index, so the row has to be accessed.

Anonymous 3091

SQL Server Assertion <simpletypes.cpp> stack dump when converting float to varchar with 128 style

sql-server-2014sql-server-2012

Anonymous 2530Anonymous 2530

14>1. what’s wrong with convert style 128?

Paul White

7This must be a bug with earlier versions of SQL Server. You can see it in action [with 2014 on db<>fiddle](https://dbfiddle.uk/um8qeyDl).

Jack Douglas