Un très bon article de John Papa à découvrir dans le numéro d'octobre du MSDN Magazine.
In this article I focus on using CTEs to address common development scenarios.
- describing how CTEs work
- scenarios they can be used to address
- advantages of using CTEs versus using traditional T-SQL constructs, such as derived tables, views, and custom procedures
- several examples
- how and where they can be used (where not to)
- how CTEs handle recursive logic
- define how a recursive CTE operates
Designing SQL Server's Common Table Expressions (CTE's) - John Papa [MVP C#]
There are no comments yet...Kick things off by filling out the form below.