第239章你不会和星兽那个了吧 (2 / 7)
         join sys.plan_guides as pg on pg.scope_object_id = t.object_id

         where @iter_no = t.rank and t.object_type in (@sp, @udf, @tr) and (t.object_svr IS null and t.object_db = db_name())

         set @rows = @rows + @@rowcount

         -- synonym refrences object

         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 s.object_id, s.name, SCHEMA_NAME(s.schema_id), t.object_db, @synonym, t.object_id, t.object_name, t.object_schema, t.object_db, t.object_type, 0, @iter_no + 1

         from #t1 as t

         join sys.synonyms as s on object_id(s.base_object_name) = t.object_id

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

         set @rows = @rows + @@rowcount

         -- SOFT DEPENDENCIES

         DECLARE name_cursor CURSOR

         FOR

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

更多完整内容阅读登陆

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