SQL101

t-sql

SQL 101 – UPDATE

Previously, I showed you how to get new information into a SQL database. This time I'll show you how to make changes to that data, once it's in there. The basic

microsoft sql

SQL101-Homework Assignment #2 Answer Key

Here are my answers to the questions based on AdventureWorks. I recently updated the answers to work with the 2008R2 version of Adventureworks. If your

SQL101

SQL101-Homework Assignment #2

SELECT with JOIN Here are a few more problems to practice with. Again, practice these queries against a copy of AdventureWorks. Now we're going to start

SQL101

SQL101-Homework Assignment #1 Answer Key

As promised, here are my answers to the first homework assignment. If you have something different, please get in touch with me so we can discuss the

microsoft sql

SQL101-Homework Assignment #1

Here are some practice problems for you to attempt using what you've learned so far about SELECT Statements.  Please write the following queries against any

microsoft sql

SQL 101 – JOIN

Overview I want to cover a fundamental topic for SQL programming. This is the topic you should start studying right after you have a basic understanding of

microsoft sql

SQL 101 – GROUP BY

Consider the following table, orders. buyer         productName  purchaseDate   qtyPurchased     pricePaid -------------

microsoft sql

SQL 101 – Summarizing Data

This is the last of the lessons on functions for the 100 level.  I hope you've enjoyed them so far, but it's time to wrap these up! When beginning to learn

t-sql

SQL 101 – System Functions

There are many functions built in to SQL 2000. I'm not going to cover them all, since many of them you won't have a need for until you really dig in deep with

microsoft sql

SQL 101 – Date Manipulation Functions

Welcome back!  This post is a followup to the post about string functions.  The difference is this time, we're discussing functions that manipulate

microsoft sql

SQL 101 – Calculated Fields

When working with SQL you will inevitably be asked to return data from your database in a way it's not stored.  You'll be asked to return city, state and zip

SQL101

SQL 101 – The Advanced LIKE Clauses

As I promised, this is my post on advanced LIKE clauses.  Previously I've only shown you how to do a wildcard search that would act like the dos command dir