In case you haven’t had a chance to play with them Common Table Expressions (CTEs) are pretty cool. Basically you can define a temp table and do operations against that table all on one statement. One of the things I’ve found most awesome about CTEs is using them for recursive logic! Here’s a contrived example… Continue reading Recursive Common Table Expressions
Ok, let’s cover another topic you’ll need to know in order to pass the 70-433. You’re going to need to be familiar with what triggers can do. When you get ready for the 70-451, you’ll need to know more about when triggers should be used. I wanted to use the scene from Raiders of the… Continue reading 70-433: So, When Do You Want To Use Triggers?
When you’re getting ready for the 70-433, you’re going to want to be familiar with constraints. They’re useful tools for setting up data integrity checks inside the database itself. Yeah, I’m going to reference The Matrix here, but learning to manipulate Constraints is a little like learning to bend spoons. There Is No Spoon The… Continue reading 70-432: Know Your Constraints