group on words in a varchar attribute
postgresql
Anonymous 2230 Anonymous 2230
4 If the words in your case are always going to be separated by the same character (like a space, for instance), you could try using the [`split_part()`](https://www.postgresql.org/docs/current/functions-string.html#id-1.5.8.10.7.2.2.31.1.1.1) function instead of regular expressions.
Andriy M
What allows SQL Server to trade an object name for a string passed to a system procedure
sql-server
JJS JJS
4 The first argument to the system stored procedure [`sp_helptext`](https://msdn.microsoft.com/en-us/library/ms176112.aspx) is:
SE Anon or Wiki user
Is it possible to use OPENROWSET to import fixed width UTF8 encoded files?
sql-server azure-sql-database
Martin Smith Martin Smith
6 One workaround is to just change the format file to bring the whole line in, in bulk, and do the substring-ing in TSQL
Martin Smith
4 > from which I conclude the `LENGTH` is counting bytes rather than characters.
Paul White
Enmascare data whit values short. 2
postgresql
Anonymous 2226 Anonymous 2226
5 `pgp_sym_encrypt()` is provided by the extension [pgcrypto](https://www.postgresql.org/docs/current/pgcrypto.html). If it works in your local database, then you have installed the extension there.
Truilus
combine connected data from rows into one 2
Anonymous 2218 Anonymous 2218
pg_ctl error on Postgres upgrade
Big Clyde Big Clyde
IF statement in Maria DB 1
Anonymous 2191 Anonymous 2191
4 Not a MariaDB or phpMyAdmin expert but I am *guessing* the issue might have to do with specifying a delimiter for a compound (multi-statement) command. Your trigger's body consists of multiple statements, and they need to have delimiters between them. The semi-colon is the standard delimiter. But phpMyAdmin may also be using the semi-colon as a *batch* delimiter, it looks for semi-colons in your code to split it into pieces in order to feed MariaDB with your code piece by piece, rather than as a single script. This way your trigger script is mercilessly ripped apart and MariaDB ends up getting the first fragment of it as just
Andriy M
Access plan for DB2 cannot be calculated - lack permission on SYSPROC.SYSINSTALLOBJECTS 1
db2
AngocA AngocA
how to add aircraft company name or the transporter and make it shown beside each column 1
mysql
Anonymous 2193 Anonymous 2193
SQL Server Storage sql_variant
sql-server-2008-r2
ooutwire ooutwire
6 The first 2 answers are from the SQL Server Internals Book p.278
Martin Smith
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.