some_user54
Re:SQL: One of the most valuable skills
on Wednesday February 13, 2019 @02:03PM (#19155692)
There is no need for ranting, if you need to reuse expression from select you could simply use `LATERAL JOIN` or `CROSS APPLY`: https://blog.jooq.org/2014/01/06/the-sql-languages-most-miss... Please check comment section of this blog
Re:SQL Server Error Handling Gotchas
on Monday September 17, 2018 @11:35AM (#18006881)
If you want to trully know how thing works I suggest great blog:
http://sommarskog.se/error_handling/Part1.html http://sommarskog.se/error_handling/Part2.html http://sommarskog.se/error_handling/Part3.html
More than 100 pages of technical knowledge.
And presentation: http://www.sommarskog.se/present/WhenThingsGoWrong%20(SQLSat...
Re:How PostgreSQL’s SQL dialect stays ahead of its competitors [PDF sl...
on Sunday July 22, 2018 @08:14AM (#17586356)
Is it correct that SQL Server does not support IDENTITY(slide 29)?
IDENTITY property is supported from as far as I can remember: https://docs.microsoft.com/en-us/sql/t-sql/statements/create...
Second approach is DEFAULT with sequence.
CREATE SEQUENCE seq; CREATE TABLE tab(i INT DEFAULT NEXT VALUE FOR seq, b VARCHAR(100))
Re:Rise of Streaming SQL
on Monday June 18, 2018 @03:22PM (#17340943)
"Patterns. Finally, let’s assume that we want to continuously detect whether the temperature has changed more than 20% within any five-minute period. This query is impossible to do efficiently with standard SQL."
This is completely untrue. SQL is more than capable of pattern detection. For example Oracle MATCH_RECOGNIZE clause: https://docs.oracle.com/database/121/DWHSG/pattern.htm#DWHSG...
But to make thing clear, we need to move on from SQL-89 mindset. SQL is really powerful Turing complete language. Row pattern recognition is part of SQL standard (ISO/IEC TR 19075-5:2016) https://modern-sql.com/blog/2017-06/whats-new-in-sql-2016