Viewing profile — some_user54

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-m…

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/…

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/statemen…

"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…