SQL Server
concepts with Sachin Agrawal.....
Existence of partition function for given value
SELECT ‘partition function exist for given value’
FROM sys.partition_functions
fn
INNER JOIN sys.partition_range_values val
ON fn.function_id = val.function_id
WHERE fn.name = '<partition function name>'
AND val.value = '<value>'
No comments:
Post a Comment
‹
›
Home
View web version
No comments:
Post a Comment