Benefits of Common Table Expressions
On this episode of Joes 2 Pros SQL server unlocked series we present a topic for anyone who has ever been exposed to SQL Server, Common Table Expressions.
A CTE is memory resident table. You are pulling from that query and giving it a name. This table adds enhancements to the old tables. It allows you to open up to new people without having an increased security risk. This is extremely beneficial for anyone who is exposed to SQL Server as keeping your content safe is a top concern for most organizations.
In this video, he will take you through a very real example from a department store quarterly reporting. He wants to do a seasonal reporting from all the departments of a store excluding snow sports and cooking. He shows you how to make the code more simple and reduce human error.
Having CTE knowledge will be greatly beneficial to you in your everyday career. Please be sure to follow along our blog series. Stay tuned next week to learn more about Dynamic SQL. To learn more about he benefits of common table expressions view our course Developer 2012 Volume 2 Video 10.1.
See more at: http://www.joes2pros.com/joes2pros/co...
Full Blog: http://joes2prosblog.social27.com/