1 --插入选中了父节点的id 2         while CHARINDEX(',',@PMenuIds)>1 3         begin      4            5           DECLARE @PMenuId INT; 6           SET @PMenuId=LEFT(@PMenuIds,CHARINDEX(',',@PMenuIds)-1);                                           7            8           --得到一个RightId，插入 9           INSERT INTO RoleMenu(RoleCode,MenuID,Valid,CreatorID,CreateTime,UpdateEmployeeID,UpdateTime,IsParentNode)VALUES(@Code,@PMenuId,@Valid,@UpdateEmployeeID,GETDATE(),@UpdateEmployeeID,GETDATE(),1);10                         11           12           --取到一个，删除一个13           SET @PMenuIds=STUFF(@PMenuIds,1,CHARINDEX(',',@PMenuIds),'');14          print @PMenuIds;15         end            16         INSERT INTO RoleMenu(RoleCode,MenuID,Valid,CreatorID,CreateTime,UpdateEmployeeID,UpdateTime,IsParentNode)VALUES(@Code,@PMenuIds,@Valid,@UpdateEmployeeID,GETDATE(),@UpdateEmployeeID,GETDATE(),1);17