摘要:
--查找父,包括自己CREATE PROC [dbo].[usp_spGetParentsID]@InputID INT--@ParentID UNIQUEIDENTIFIER OUTPUTASBEGIN DECLARE @strResult Nvarchar; set @strResult=''; with cte as(select ID,ParentID from Zitian_Categories where id=@InputIDunion allselect a.id,a.ParentID from Zitian_Categories a join cte b ..
阅读全文