0

Possible Duplicates:
What is the purpose of system table table master..spt_values and what are the meanings of its values?
Why (and how) to split column using master..spt_values?

I have some dynamic SQL, I have this lines that will be executed, whats the meaning of spt_values, and the type='P' 

declare @Sql nvarchar(max)
select @Sql = ISNULL(@sql + ',', '') + QUOTENAME(RIGHT(number,10))
    from master..spt_values 
    where type='P' and number between 1 and (select COUNT(*) From tableName)
Community
  • 1
  • 1
edgarmtze
  • 23,987
  • 75
  • 226
  • 373

1 Answers1

0

spt_values is a table in the master database. As such, it's meant for internal SQL Server use only, and is undocumented to the public.

Basically the code you've got is a quick way to get your hands on a resultset of numbers.

p.campbell
  • 95,348
  • 63
  • 249
  • 319