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
Latest
personal
Happy Birthday to Me!
I'll get back to the SQL 101 series as soon as I'm done celebrating today! Thank you all for the well wishes you've sent! I'm truly grateful to have all these
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
Untitled Post - http://toyboxcreations.net:80/wp-json/oembed/1.0/embed?url=http://toyboxcreations.net/2005/07/sql-101-select-filtering-results/
{"version":"1.0","provider_name":"Shannon Lowder","provider_url":"https:\/\/web.archive.org\/web\/20171024023708\/http:\/\/toyboxcreations.net","author_name":"Shannon Lowder","author_url":"https:\/\/web.archive.org\/web\/20171024023708\/http:\/\/toyboxcreations.net\/author\/slowder\/","title":"SQL 1
microsoft sql
SQL 101 – What is SQL?
SQL, pronounced S - Q - L or sequel, stands for structured query language. It's the language you use to tell a database what you want to do. It's been
microsoft sql
SQL 101 – What is a Database
The term database is used for many different meanings. But if you compared them all, I think you would find that databases are all collections of data that