alter procedure [dbo].[Admin_GetMenu]
@GroupID int,
@Roles nvarchart(500)
asdeclare @strSql nvarchar(1000)
set @strSql='select * from Admin_RightModule where GroupID='+Cast(@GroupID as nvarchar)+' and ModuleID in (select distinct ModuleID from admin_RightFunction where FunctionID in ('+ @Roles+'))'execute(@strSql)execute Admin_GetMenu 30,'100101,100102,100103,100104,100105,200101,200102'
报这个错误 超出了存储过程、函数、触发器或视图的最大嵌套层数(最大层数为 32)。
怎么解决呀,谢谢,求教了。
@GroupID int,
@Roles nvarchart(500)
asdeclare @strSql nvarchar(1000)
set @strSql='select * from Admin_RightModule where GroupID='+Cast(@GroupID as nvarchar)+' and ModuleID in (select distinct ModuleID from admin_RightFunction where FunctionID in ('+ @Roles+'))'execute(@strSql)execute Admin_GetMenu 30,'100101,100102,100103,100104,100105,200101,200102'
报这个错误 超出了存储过程、函数、触发器或视图的最大嵌套层数(最大层数为 32)。
怎么解决呀,谢谢,求教了。
alter procedure [dbo].[Admin_GetMenu]
@GroupID int,
@Roles nvarchart(500)
as
begin
declare @strSql nvarchar(1000)
set @strSql='select * from Admin_RightModule where GroupID='+Cast(@GroupID as nvarchar)+' and ModuleID in (select distinct ModuleID from admin_RightFunction where FunctionID in ('+ @Roles+'))'execute(@strSql)
endexecute Admin_GetMenu 30,'100101,100102,100103,100104,100105,200101,200102'--不要再存储过程里面执行当前存储过程,那不死循环了吗!!!!
alter procedure [dbo].[Admin_GetMenu]
@GroupID int,
@Roles nvarchart(500)
asdeclare @strSql nvarchar(1000)
set @strSql='select * from Admin_RightModule where GroupID='+Cast(@GroupID as nvarchar)+' and ModuleID in (select distinct ModuleID from admin_RightFunction where FunctionID in ('+ @Roles+'))'execute(@strSql)
go
execute Admin_GetMenu 30,'100101,100102,100103,100104,100105,200101,200102'