第239章你不会和星兽那个了吧 (7 / 7)
         END

         CLOSE name_cursor

         DEALLOCATE name_cursor

         update #t2 set object_id = obj.object_id, object_name = obj.name, object_schema = schema_name(obj.schema_id), object_type = @u

         from sys.objects as o

         join sys.objects as obj on obj.object_id = o.parent_object_id

         where o.object_id = #t2.object_id and (#t2.object_type = @obj OR o.parent_object_id != 0) and #t2.rank = @iter_no + 1

         insert #t1 (object_id, object_name, object_schema, obj

        【This chapter is finished reading】

更多完整内容阅读登陆

《墨缘文学网，https://wap.mywenxue.org》