7-85.sql

来自「sql2000工程实践一书的代码 可以直接调试」· SQL 代码 · 共 8 行

USE master
GO
SELECT 'Index Name' = i.name, 
   'Statistics Date' = STATS_DATE(i.id, i.indid)
FROM sysobjects o, sysindexes i
WHERE o.name = 'employee' AND o.id = i.id
GO