If I write in SQL Server :
SELECT number FROM master..spt_values WHERE Type = 'P' ORDER BY Number
I get a list of sequential numbers which I can already use, instead of writing a table with sequential numbers.
This can be much helpful for small joins, row numbering etc.
I was wondering if there are other hidden tables like this one which can help me do other things as well? For example, I might want to
select someNonImportantTextColmn from master..unknown and to apply a function of mine.
Where can I find a complete list of these "help tables"?