Compare the Data in Two Tables

These queries are used to compare the data in two tables.   In these examples all the rows in each table is retrieved and compared using the UNION ALL command.  I would recommend adding additional WHERE criteria for very large tables to reduce the number of rows that will be compared.These SQL statements are based on […]

Finding a particular column in All tables

The script can be used to find all the tables that have the particular column name in it.

MEDIAN sp for SQL 2000

I wrote this to calculate the median on a record set. All you need to pass is the table name and column name. If you would like to filter the record set, create a view that displays the correct record.The limitation of not being able to pass arrays to Stored procedure or functions was the […]

Writing Simple Select Statements - Part 3

In this video, Kathi continues her T-SQL series and exands how to use the WHERE clause.

What is the result of the following query?...

Writing Simple Select Statements - Part 2

In this second part video from Kathi, she covers how to write T-SQL in much more indepth. She covers how to handle NULLs and many more items in this video.

TOP in SQL Server 2005

There are so many new features in SQL Server 2005 that there's one that can make a significant impact in solving many different types of problems. Andy Warren takes a look at one of the features that has been enhanced and is extremely useful, albeit quirky: TOP.

Invoke UDFs that accept tables with SQL Server 2005's APPLY operator

Tim Chapman discusses using table valued functions with the APPLY function.

Writing Simple Select Statements

In this video, you'll learn how to write basic select statements. This beginner video takes you from the ground up writing T-SQL.

Script Generator

It is a modified version of original script I found on net. This script creates conditional Update statements too.