Usages of CONTEXT_INFO

How many of you have ever used SET CONTEXT_INFO in your SQL Server applications? Chances are it is not something you have been exposed to, but new author Yousef Ekhtiari brings us an example of how this particular construct can be used in your application.

What are the three possible functions of the...

insert mytable select ''
insert mytable select ' '
select * from...

Joining Tables Part 1

In this video for beginners you'll begin to learn how to write queries that use more than one table using T-SQL. Kathi walks you through common tactics to efficiently pull out data from a normalized system.

What does a @@fetch_status of -2 mean in...

Truncate Log File For All User Databases

The log file is too big? This is the solution

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.