sql递归

alter   PROCEDURE  findPlace(     @pid int --参数)asbegindeclare @c intDECLARE @p INTDECLARE @i intSET @c=0SET @i=0SELECT @c=(select COUNT(*) FROM pre_common_district WHERE node_id=@pid)WHILE(@c>0)beginSELECT * FROM pre_common_district WHERE node_id=@pidSELECT @p=(select TOP 1 id3 FROM pre_common_district WHERE node_id=@pid AND id1 NOT IN(SELECT TOP (@i) t.id1 FROM pre_common_district t WHERE node_id=@pid))exec findPlace @p;SELECT @c=@c-1;select @i=@i+1;endend