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
chat
transcript

Enter question or answer id or url (and optionally further answer ids/urls from the same question) from

Separate each id/url with a space. No need to list your own answers; they will be imported automatically.