Treat your database code like code.

Using Exotic Joins in SQL Part 1

by Chris Cubley

SQLServerCentral.com

T-SQL

When most developers think of joins, they think of a.SomethingID = b.SomethingID. This type of join, the equijoin, is vitally important to SQL programming; however, it only scratches the surface of the power of the SQL join. This is the first in a series of articles that will look at several different types of exotic joins in SQL. This article will focus on using the BETWEEN operator in joins when dealing with range-based data.

Installing SQL Server Agent on SUSE Linux

by Additional Articles

MSSQLTips.com

SQL Server Agent

Manvendra Singh explains how to install SQL Server Agent on SUSE Linux server, so that you can create SQL Server Jobs to schedule repetitive work.

Jumping Ahead

by Steve Jones

SQLServerCentral.com

Editorial

There are times when you look back and times when you look forward in your career. Sometimes, however, we might try to push forward too fast.

How to Find Out Which Database Object Got Deleted

by Additional Articles

Database Journal

Greg Larsen shows you how to use the Transaction ID value to identify the object_id for a deleted table.

A Data ID

by Steve Jones

SQLServerCentral.com

Editorial

The idea of a universal data ID has Steve Jones interested and concerned.

Responsibility to Learn

by Grant Fritchey

SQLServerCentral.com

Editorial

“I would educate myself, and that I would never stop educating myself. It was my responsibility to keep learning.” Who said that? Albert Einstein? Da Vinci? Stephen Hawking? None of the above. That statement came from the Demon of the rock band KISS, Gene Simmons. If a rock & roll legend knows that it’s on […]

Is It Time To Stop Using IsNumeric()?

by Additional Articles

SimpleTalk

ISNUMERIC()

The old system function IsNumeric() often causes exasperation to a developer who is unfamiliar with the quirks of Transact SQL. It seems to think a comma or a number with a 'D' in the midde of it is a number. Phil Factor explains that though IsNumeric has its bugs, it real vice is that it doesn't tell you which of the numeric datatypes the string parameter can be coerced into, and because it doesn't check for overflow. Phil comes to the rescue with a couple of useful alternatives, one of which works whatever version of SQL Server you have, and which tell you what datatype the string can be converted to.