Get a range of numbers

If you need to get a range sequence of numbers this script can help you to acomplish it. For example : the sequency of numbers between -5 and 5 or 1 and 200, etc..

How to query dBase .dbf from SQL 2012 64-bit

Query dBase .dbf Files From SQL 2012 64-bit.

Sequences I

SELECT options

TSQL TestBits function for rapidly testing multiple switch settings

Are multiple binary switches becoming hard to manage? The TestBits function can help with that.

DateTime Functions

Did you say denormalize, why?

How to display data from 1-to-many in a single record!

NOT BETWEEN

Find Customers Who Bought "A" and "B" But Not "C" (SQL Spackle)

A simple problem that can become complex in T-SQL. How do you find the rows that match 2 conditions, but not a third, in an efficient manner. MVP Jeff Moden gives us a solution.

Dealing with custom date formats in T-SQL

Should I be formatting dates on the database side? What tools can I use in SQL Server to format and parse dates? This article helps you decide which one best suits your needs.