Adjective: shonky (comparative shonkier, superlative shonkiest)
- (Australia, New Zealand, Britain, informal) Of poor or dubious quality, shoddy, unreliable; deviously dishonest, fraudulent.
- 1986, Sociological Association of Australia and New Zealand, ANZJS: The Australian & New Zealand Journal of Sociology, Volume 22, page 475,
- The argument gets even shonkier when they claim that the boundary between clerical and administrative work is difficult to define anyway, and that routinisation and fragmentation have affected lower and middle management too (pp. 95–6).
- 2000, Australian Senate, Parliamentary Debates (Hansard), page 13548,
- The committee heard much evidence that this is a farce, yet this government have continued to try to pretend that their forecast, based on the shonkiest of assumptions—their model, with the shonkiest of assumptions—is really what is going to happen.
Well well, I just learned something.
So it turns out that with CHECK CONSTRAINTS and UPDATES, the CONSTRAINT only gets checked if one of the columns referenced in the CONSTRAINT changed.
In your case, your CONSTRAINT is checking a UDF that you pass ItemID to.
In your UPDATE, presumably you...
If you're using PostgreSQL, put a SET RETURN FUNCTION in the ORDER BY clause.
CREATE TABLE foo AS
SELECT *
FROM ( VALUES (1,'A'),(2,'B'),(3,'C') ) AS x(id,name);
And, then
SELECT id,name
FROM foo
ORDER BY 1, generate_series(1,2);
id | name
----+------
1 | A
1 | A
2 | B
2 | B
3 |...
In mathematical logic, Russell's paradox (also known as Russell's antinomy), is a set-theoretic paradox discovered by the British philosopher and mathematician Bertrand Russell in 1901. Russell's paradox shows that every set theory that contains an unrestricted comprehension principle leads to contradictions. The paradox had already been discovered independently in 1899 by the German mathematician Ernst Zermelo. However, Zermelo did not publish the idea, which remained known only to David Hilbert, Edmund Husserl, and other academics at the University of Göttingen. At the end of the 1890s, Cantor...
52
My first thought would be to use the INFORMATION_SCHEMA first, so you get to know (in one query for all tables in the MySQL instance) which tables have an active column and then use that info to construct your queries. And this is probably the most sane approach.
There is one other, tricky way t...
The following query uses the same idea as in this amazing answer by ypercube:
SELECT x.*
FROM (SELECT NULL AS SomeCol) AS dummy
CROSS APPLY
(
SELECT
ID,
SomeCol AS MyTest
FROM dbo.Customers
) AS x;
It works like this:
if dbo.Customers has a column named SomeCol, then SomeCol in S...
ARJ (Archived by Robert Jung) is a software tool designed by Robert K. Jung for creating high-efficiency compressed file archives. ARJ is currently on version 2.86 for DOS and 3.20 for Microsoft Windows and supports 16-bit, 32-bit and 64-bit Intel architectures.ARJ was one of many file compression utilities for DOS and Windows during the early and mid-1990s. Parts of ARJ were covered by U.S. Patent 5,140,321 (expired). ARJ was well documented, and was the most feature rich compression utility at the time, with over 150 documented command line switches, which contributed to its wide-spread adoption...
