spt_values ???? what does that do ???

[CDuffy]

Hi everybody
I would like to have more information upon the following procedure spt_value. I find it in the definition of a variable to convert data to KB
Does some one know exactly what that query is doing ? why does have it to run form master?

select @pagesize = v.low / 1024 from master..spt_values v where v.number=1 and v.type=N'E'

cheers
Patrick

 

[cdukes]

spt_values is not a system stored procedure it is a system table.

The table appears to contain SQLServer configuration data.

The Query that have provided, calculates the page size in K of the SQLServer configuration. You will need to determine what this is being used for.

Hope this helps,

Chris Dukes

 

[ColinM]

spt_values tables is a list of values and their name. This is so that you can refer to the name, as it is a lot easier to remember than the number. Similar to constants in VB.

And their in the master database to keep them out of your way!