我在SQL Enterprise 2005中有一个分区表.我需要查询PARTITION FUNCTION以找到它的分区范围.什么SQL查询会给我这些值?
从SQL分析器中看到管理工作室生成用于创建函数的脚本
SELECT sprv.value AS [Value], sprv.boundary_id AS [ID] FROM sys.partition_functions AS spf INNER JOIN sys.partition_range_values sprv ON sprv.function_id=spf.function_id WHERE (spf.name=N'fnPartitionLast30Days') ORDER BY [ID] ASC