SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: 李盼
-- Create date: 2018-3-17
-- Description: 获取目录
-- =============================================
alter PROCEDURE GetMuLu(
@leftmenuid varchar(50),
@fanhui nvarchar(max) output
)
AS
BEGIN
SET NOCOUNT ON;
with tempqw(LeftMenuID,LeftMenuName,TopMenuID)
as(
SELECT LeftMenuID,LeftMenuName,TopMenuID FROM Cus_LeftMenu where LeftMenuID=@leftmenuid
union all
--递归条件
SELECT a.LeftMenuID,a.LeftMenuName,a.TopMenuID FROM Cus_LeftMenu a
inner join
tempqw b
on a.LeftMenuID=b.TopMenuID
)
select * from tempqw;
END
@leftmenuid = N'm17c8c1',
@fanhui = @fanhui OUTPUT
SELECT @fanhui as N'@fanhui'
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: 李盼
-- Create date: 2018-3-17
-- Description: 获取目录
-- =============================================
alter PROCEDURE GetMuLu(
@leftmenuid varchar(50),
@fanhui nvarchar(max) output
)
AS
BEGIN
SET NOCOUNT ON;
with tempqw(LeftMenuID,LeftMenuName,TopMenuID)
as(
SELECT LeftMenuID,LeftMenuName,TopMenuID FROM Cus_LeftMenu where LeftMenuID=@leftmenuid
union all
--递归条件
SELECT a.LeftMenuID,a.LeftMenuName,a.TopMenuID FROM Cus_LeftMenu a
inner join
tempqw b
on a.LeftMenuID=b.TopMenuID
)
select * from tempqw;
END
GO
******************执行方法如下*************************
USE [JudicialExamination]
GO
DECLARE @return_value int,
@fanhui nvarchar(max)
EXEC @return_value = [dbo].[GetMuLu]@leftmenuid = N'm17c8c1',
@fanhui = @fanhui OUTPUT
SELECT @fanhui as N'@fanhui'
GO