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
Bug with run-time constants and ScalarString attribute in ShowPlanXML
Blog
sql-server
i-onei-one
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
Passwords for Database Logins1817
Blog
faq
John K NJohn K N
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