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…
Tag: 70433
70-433: So, When Do You Want To Use Triggers?
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…
70-432: Know Your Constraints
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…
70-433:Dynamic Management Views
I just laid hands on a great little guide to the Dynamic Management Views in SQL Server 2008. It’s a great introduction / quick reference guide sort of book. With it, as long as you know what information you’re looking for, you can jump right to the view that can help you find the data…
Microsoft Exam 70-433 (part 2)
I’m putting together a new series to cover the materials you’ll need to know in order to pass the 70-433. Microsoft’s exam that covers Database Development using Microsoft SQL Server 2008. I’m going to list the topics covered in several posts, each one will include links to details to those topics. If you have any…
Microsoft Exam 70-433
I’m putting together a new series to cover the materials you’ll need to know in order to pass the 70-433. Microsoft’s exam that covers Database Development using Microsoft SQL Server 2008. I’m going to list the topics covered in several posts, each one will include links to details to those topics. If you have any…
SET IDENTITY_INSERT
Let’s say you have the following table on two servers, one in development and one in production. CREATE TABLE person ( personID INT IDENTITY(1,1) , firstName VARCHAR(50) , lastName VARCHAR(50) ) You’re about to implement a new query, but you need to test it out in development before you move it to production. The problem…
70-433:OUTPUT and IDENTITY
Let’s look at a scenario you’ll need to be able to handle if you hope to pass the 70-433. This scenario requires you to understand the IDENTITY property for a column as well as how to return the identities created for rows inserted. Let’s start by creating a table to store widgets. We want an…