Common Sweden Conference 2024

SQL has become very powerful. It includes for example recursions, multi-dimensional grouping, OLAP specifications, IFS and Webservice access …. But not everybody will be able to code complex queries … and this is not necessary as long the programmer can easily use them.
With SQL Views complexity can be hidden. Since a SQL View can be used in a SELECT statement like a table even beginners can write reports based on complex SELECT statements.
How ever, sometimes more than one step is needed to retrieve the desired data. In this situation User Defined Functions (UDFs) or User Defined Table Functions come into play.