70%的程式碼都是多餘無用的

• 70%的程式碼都是?:
  http://www.infoq.com/news/2007/10/reducing-code-waste
  http://smoothspan.wordpress.com/2007/09/04/70-of-the-software-you-build-is-wasted-part-1-of-series-of-toolplatform-rants/
• C++程式碼並沒有比C程式碼來得具有重用性: http://paulspontifications.blogspot.com/2007/09/composability-and-productivity.html

使用SQL Server 2005執行遞迴查詢

SQL Server 2005的新功能Common Table Expressions (CTE)可以用來作遞迴的SQL查詢

;WITH MenuCTE(MenuKey, ParentMenuKey, MenuName) AS
(
-- Anchor Query
SELECT MenuKey, ParentMenuKey, MenuName FROM Menu WHERE MenuKey = 1
UNION ALL
-- Recursive Query
SELECT m.MenuKey, m.ParentMenuKey, m.MenuName FROM Menu m INNER JOIN MenuCTE r ON m.ParentMenuKey = r.MenuKey
)

SELECT MenuKey, ParentMenuKey, MenuName FROM MenuCTE


參考資料：http://www.infoq.com/news/2007/10/CTE