Common Table Expressions in MS SQL Server

CTE’s or Common Table Expressions is a feature that is available since MS SQL Server 2005.
It’s a kind of temporary view or to translate it in NAV lingo, temporary tables. CTE’s only exist
in the query where they are declared and can be used as it was a regular table.

Bron : Something, something, something C/Side
Lees meer…

Leave a Comment.