摘要:
常见于目录表结构中(树状结构)如项目目录表,根据目录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( ... 阅读全文
posted @ 2009-12-10 17:58
Chr☆s
阅读(3908)
评论(0)
推荐(1)