Month: February 2009

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…

Let’s cover another scenario that uses knowledge you’ll need in order to pass the 70-432.  This time we’re going to work with constraints.  We all know that you can declare a unique constraint on a column you where you want to be sure you won’t get any duplicates. But do you know how to deal…

Today we’re going to cover a scenario you might face at work, one that’s also a topic you’d need to know in order to pass the 70-432 Database Administrator’s exam.  If you have any questions in your preparation for the 70-432, let me know.  I’ll be happy to help in any way! Now for the…