dm_db_index_physical_stats->OpenRowset

SET QUOTED_IDENTIFIER ON

SET ANSI_NULLS ON

GO

create function sys.dm_db_index_physical_stats

(

@DatabaseId SMALLINT = 0,

@ObjectId INT = 0,

@IndexId INT = -1,

@PartitionNumber INT = 0,

@Mode nvarchar(20) = NULL

)

returns table

as

return select * from OpenRowset

(

IndexAnalysis,

@DatabaseId,

@ObjectId,

@IndexId,

@PartitionNumber,

@Mode

)

GO

posted on 2017-02-06 22:46  石下江的太阳光  阅读(100)  评论(0编辑  收藏  举报

导航