Tuesday, March 17, 2009

Auxiliary numbers table - MSSQL Technique

Auxiliary numbers table is a T-SQL technique. It uses a simple table (say num) with one column with a sequence of numbers. Using the num table we can avoid loop structres

http://sqlserver2000.databases.aspfaq.com

No comments:

Post a Comment

Missing Date

I need to check in a table, is the all day data available, here is the handy script to check the same.. DECLARE @startdate DATETIME ...