LOB string splitter with ordinals in SQL Server 2016
9
sql-server-2016
Paul White
Paul White
11
This inline TVF converts the input string to JSON array format, then uses default `OPENJSON`.
Paul White
SQLITE SUM of timestamp values
sqlite
DeFacto
DeFacto
0
Your fiddle was from 3.27, Since that some date/time function got improved
Luuk
How to check active IDs from six months ago
3
db2
Sam
Sam
0
Here 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
dbfiddle
mysql-5.6
Vérace
Vérace
2
Triggers 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-one
i-one
Need help handling NULLs in PostgreSQL
1
postgresql-15
Evan845
Evan845
3
Well, 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
toraritte
toraritte
Passwords for Database Logins
18
17
Blog
faq
John K N
John K N
Cumulative SUM
1
sqlite
DeFacto
DeFacto
4
The 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 SQlite
10
sqlite
DeFacto
DeFacto
4
Yes, it's easy to do this with the [`case` expression](https://www.sqlite.org/lang_expr.html#the_case_expression)
Jack Douglas