第242章被困百草堂 (3 / 9)
         from #t1 as t

         join sys.foreign_keys as fk on fk.parent_object_id = t.object_id

         join sys.tables as tbl on tbl.object_id = fk.referenced_object_id

         where @iter_no = t.rank and t.object_type = @u and (t.object_svr IS null and t.object_db = db_name())

         set @rows = @rows + @@rowcount

         -- uddts referenced by uda

         insert #t1 (object_id, object_name, object_schema, object_db, object_type, relative_id, relative_name, relative_schema, relative_db, relative_type, schema_bound, rank)

         select tp.user_type_id, tp.name, SCHEMA_NAME(tp.schema_id), t.object_db, case when tp.is_table_type = 1 then @udtt when tp.is_assembly_type = 1 then @udt else @uddt end, t.object_id, t.object_name, t.object_schema, t.object_db, t.object_type, 1, @iter_no + 1

         from #t1 as t

         join sys.parameters as p on p.object_id = t.object_id

         join sys.types as tp on tp.user_type_id = p.user_type_id

         where @iter_no = t.rank and t.object_type = @uda and t.object_type = @uda and tp.user_type_id>256

         set @rows = @rows + @@rowcount

         -- assembly referenced by assembly

  The content is not finished, continue reading on the next page

更多完整内容阅读登陆

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