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
t-sql
microsoft sql
SQL 201 – Sub Queries
Sub queries or nested queries are complete queries wrapped inside of another complete query. Some times this technique is used as a replacement for a JOIN
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 201 – String Manipulation Functions
In a previous post I introduced you to calculated fields, and mentioned there were many other functions you could use to compute values or columns. It's time
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
t-sql
SQL 101 – SELECT, Filtering Results (Part 2)
In the previous post, I covered the WHERE clause. You should now feel pretty comfortable limiting the number of rows you get to return based on the values
t-sql
SQL 101 – SELECT, Filtering Results
After you learn how to get data out of a table with the SELECT command, you'll soon ask the question, how do I limit the number of results I get back. Well, If
microsoft sql
SQL 101 – SELECT
The first thing you need to know when learning SQL is how to get data out of a database. This means learning the SELECT command. Using this command will get