摘要:常见于目录表结构中(树状结构)如项目目录表,根据目录Id获取其属下所有子结点:CREATE PROCEDURE [dbo].[pGetDescendedPhysicalItemCatalogs]( @PhysicalItemCatalogId int )ASset nocount onBEGIN TRY IF NOT EXISTS (SELECT * FROM [tempdb].sys.objects WHERE name = '##PhysicalItemCatalog') CREATE TABLE ##PhysicalItemCatalog( ...
阅读全文
12 2009 档案