問題描述
我最近發現了以下文章:
I recently found the following article:
http://www.tsqltutorials.com/with-common-table-表達式.php
這篇文章沒有列出它在哪個版本的 SQL Server 中可用.這在 SQL Server 2000 中是否有效，如果不能，它在哪個版本中可用?
The article doesn't list which version of SQL server this became available in. Does this work in SQL Server 2000 and if not what is the earliest version that it is usable in?
更新:我確實嘗試了一個快速測試，但該測試不起作用.我要求它在 SS2000 中不起作用以確保它不是我或我的設置.
Update: I did try a quick test and the test doesn't work. I'm asking that it doesn't work in SS2000 to ensure it isn't me or my setup.
推薦答案
SQL Server 2005 中引入了常用表表達式.
Common table expressions were introduced in SQL Server 2005.
http://www.simple-talk.com/sql/sql-server-2005/sql-server-2005-common-table-expressions/
這篇關于SQL Server 2000 中是否提供公共表表達式 (CTE)的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！