摘要: SELECT 表名 = case when a.colorder = 1 then d.name else '' end, 表说明 = case when a.colorder = 1 then isnull(f.value, '') else '' end, 字段序号 = a.colorder, 阅读全文
posted @ 2024-11-02 16:54 啃苹果的小虫 阅读(257) 评论(0) 推荐(0)
摘要: 1 查询数据库最近执行的语句SELECT TOP 1000 ST.text AS '执行的SQL语句', QS.execution_count AS '执行次数', QS.total_elapsed_time AS '耗时', QS.total_logical_reads AS '逻辑读取次数', 阅读全文
posted @ 2024-11-02 16:53 啃苹果的小虫 阅读(371) 评论(0) 推荐(0)