SQL201

microsoft sql

SQL 201 – Indexes

Indexes in Microsoft SQL are just like indexes in a book. They help you jump to the information you want more quickly. In Microsoft SQL you can index one or

t-sql

SQL 201 – Views

Previously I showed you how to create tables.  The normal goal for designing a table is to store data in such a way that each table contains one group of facts

t-sql

SQL 201 — User Defined Functions

Back in SQL 101, I introduced you to some functions, GETDATE(), ISNULL(string1, string2), etc. All of these functions come defined in Microsoft SQL before you

t-sql

TOP PERCENT

We have a multi-threaded process that grabs it's fair share records and then processes them. It basically looks at the total number of records to process, and

t-sql

Inter-Database Queries

I've had this question come up a few times now. "How do I copy data from one database to another?" It's after getting a question like that, I explain fully

t-sql

SQL 201 — CREATE PROCEDURE

Now that you have the basics of SQL, I think it's time to learn something a bit more involved. If you need to accomplish a task within SQL you will run a series

t-sql

SQL 201 – CREATE TABLE

CREATE TABLE I've showed you how to get data out of a table, put data in, change it, and delete it. But I haven't showed you how to create your own table...

t-sql

Moving Data Between Tables

Very early into my SQL career I had to get comfortable moving records around between tables and databases. There are several ways to do it, you just have to

microsoft sql

SQL 201 – Combining Query Results

Overview There comes a point in your SQL career where you will need to combine the results of several queries into one data set, and present it in one view.

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 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

String Manipulation — CAST and CONVERT

So far I’ve shown you just a few of the many string manipulation functions available in Microsoft SQL.  Today we’re adding two more of these tools to