示例15.sql

来自「SQL基础教程上的一些源码」· SQL 代码 · 共 17 行

DECLARE @db_id SMALLINT
DECLARE @object_id INT
SET @db_id = DB_ID(N'MyComplany')
SET @object_id = OBJECT_ID(N'Employees')
IF @db_id IS NULL
BEGIN
    PRINT N'Invalid database'
END
ELSE IF @object_id IS NULL
BEGIN
    PRINT N'Invalid object'
END
ELSE
BEGIN
	    SELECT * FROM sys.dm_db_index_physical_stats(@db_id, @object_id, NULL, NULL , 'LIMITED')
END
GO