- 当前位置：首页 >应用开发 >SQL Server CTEs的语法与功能
SQL Server CTEs的语法与功能
发布时间：2025-11-04 19:16:57 来源：技术快报 作者：数据库
复制---prepare test data SET NOCOUNT ON; CREATE TABLE dbo.Parts ( partid INT NOT NULL PRIMARY KEY,语法 partname VARCHAR(25) NOT NULL ); INSERT INTO dbo.Parts(partid, partname) select 1, Black Tea union all select 2, White Tea union all select 3, Latte union all select 4, Espresso CREATE TABLE dbo.BOM ( partid INT NOT NULL REFERENCES dbo.Parts, assemblyid INT NULL REFERENCES dbo.Parts, unit VARCHAR(3) NOT NULL, qty DECIMAL(8, 2) NOT NULL, UNIQUE(partid, assemblyid), CHECK (partid <> assemblyid) ); INSERT INTO dbo.BOM(partid, assemblyid, unit, qty) select 1, NULL, EA, 1.00 union all select 2, 1, EA, 1.00 union all select 3, 2, EA, 1.00 union all select 4, 3, EA, 1.00 -- perform the test WITH BOMTC AS( SELECT assemblyid, partid FROM dbo.BOM WHERE assemblyid IS NOT NULL UNION ALL SELECT P.assemblyid, C.partid FROM BOMTC AS P JOIN dbo.BOM AS C ON C.assemblyid = P.partid ) SELECT DISTINCT assemblyid, partid FROM BOMTC; 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30.31.32.33.34.35.36.37.38.39.40.
源码下载香港云服务器益华科技IT资讯网源码库亿华云企商汇服务器租用IT技术网益强IT技术网益强智未来益强编程堂全栈开发编程之道技术快报益强科技益强数据堂思维库码上建站亿华科技益强智囊团亿华智慧云益强编程舍汇智坊智能时代码力社益强科技科技前瞻益华科技益强前沿资讯益华科技极客编程多维IT资讯亿华云计算运维纵横创站工坊益强资讯优选亿华智造亿华云IT资讯网云站无忧极客码头
- Copyright © 2025 Powered by SQL Server CTEs的语法与功能,技术快报 滇ICP备2023006006号-46sitemap