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


No comments:

Post a Comment

Managing SQL Role

Recently, we had a scenario, where we need a simple SQL Role which gets read access to bunch of views.  While it was easy to create the vie...