1
CREATE PROCEDURE USP_CatalogDeleteChild
2
(
3
@catalogid nvarchar(50)
4
)
5
AS
6
SET NOCOUNT ON
7![](/Images/OutliningIndicators/None.gif)
8
DECLARE @childCatalogId nvarchar(50)
9
DECLARE @loop int
10
DECLARE @totalrow int
11![](/Images/OutliningIndicators/None.gif)
12
DELETE FROM cms_catalog WHERE [id] = @catalogid
13
BEGIN
14
----------递归,使用临时表
15
SELECT[id],identity(int) AS i INTO #tmp FROM cms_catalog WHERE parentid = @catalogid
16
SET @totalrow = @@rowcount
17
SET @loop =1
18
19
WHILE(@loop <= @totalrow)
20
begin
21
SELECT @childCatalogId = [id] FROM #tmp WHERE i = @loop
22
SET @loop = @loop+1
23
EXEC USP_CatalogDeleteChild @childCatalogId
24
end
25
END
26
GO
27![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
2
![](/Images/OutliningIndicators/None.gif)
3
![](/Images/OutliningIndicators/None.gif)
4
![](/Images/OutliningIndicators/None.gif)
5
![](/Images/OutliningIndicators/None.gif)
6
![](/Images/OutliningIndicators/None.gif)
7
![](/Images/OutliningIndicators/None.gif)
8
![](/Images/OutliningIndicators/None.gif)
9
![](/Images/OutliningIndicators/None.gif)
10
![](/Images/OutliningIndicators/None.gif)
11
![](/Images/OutliningIndicators/None.gif)
12
![](/Images/OutliningIndicators/None.gif)
13
![](/Images/OutliningIndicators/None.gif)
14
![](/Images/OutliningIndicators/None.gif)
15
![](/Images/OutliningIndicators/None.gif)
16
![](/Images/OutliningIndicators/None.gif)
17
![](/Images/OutliningIndicators/None.gif)
18
![](/Images/OutliningIndicators/None.gif)
19
![](/Images/OutliningIndicators/None.gif)
20
![](/Images/OutliningIndicators/None.gif)
21
![](/Images/OutliningIndicators/None.gif)
22
![](/Images/OutliningIndicators/None.gif)
23
![](/Images/OutliningIndicators/None.gif)
24
![](/Images/OutliningIndicators/None.gif)
25
![](/Images/OutliningIndicators/None.gif)
26
![](/Images/OutliningIndicators/None.gif)
27
![](/Images/OutliningIndicators/None.gif)