問題描述
我正在使用 sp_MSforeachtable 來獲取數據庫中特定表的行數.我想要這些按名稱排序.
I am using sp_MSforeachtable to get a rowcount of specific tables in my database. I want these ordered by name.
如何向 sp_MSforeachtable 添加 ORDER BY 子句?
How do I add an ORDER BY clause to sp_MSforeachtable?
推薦答案
我知道這個問題已經有 10 多年的歷史了，但它有超過 3000 次訪問和一堆錯誤答案.我將重新調整 Chris R. 的答案，希望將其標記為已接受的答案，而不是過于復雜的半頁 SQL 或你不能"的答案.我帶著完全相同的問題來到這里，所以它仍然是相關的，顯然并不簡單.
I understand this question is over 10 years old, but it has over 3000 visits and a bunch of wrong answers. I'm going to repurpose Chris R.'s answer in hopes of getting this marked as the accepted answer, instead of overly-complicated half-pages of SQL or "you can't" answers. I came here with the exact same question so it's still relevant and obviously not simple.
使用@whereand參數指定一個ORDER BY子句，該參數的內容被附加到內部SELECT的末尾> 通過存儲過程中的簡單 + @whereand 語句.而在 ORDER BY 1 中使用 1 表示按第一列排序.
Use the @whereand parameter to specify an ORDER BY clause, The contents of that parameter are tacked on to the end of the internal SELECT statement via a simple + @whereand in the stored proc. And using 1 in ORDER BY 1 means to order by the first column.
sp_MSforeachtable @command1='SELECT COUNT(*) AS ''?'' FROM ?', @whereand = 'ORDER BY 1'
這篇關于sp_MSforeachtable 排序依據的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！