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
  • 24,683
  • 80
  • 235
  • 386

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
  • 98,673
  • 67
  • 256
  • 322