第239章你不会和星兽那个了吧 (2 / 6)
         where@iter_no=t.rankandt.object_typein(@sp,@udf,@tr)and(t.object_svrISnullandt.object_db=db_name())

         set@rows=@rows+@@rowcount

         --synonymrefrencesobject

         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)

         selects.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#t1ast

         joinsys.synonymsassonobject_id(s.base_object_name)=t.object_id

         where@iter_no=t.rankand(t.object_svrISnullandt.object_db=db_name())

         set@rows=@rows+@@rowcount

         --SOFTDEPENDENCIES

         DECLAREname_cursorCURSOR

         FOR

         SELECTDISTINCTt.object_id,t.object_name,t.object_schema,t.object_type

         FROM#t1ast

         WHERE@iter_no=t.rankand(t.object_svrISnullandt.object_db=db_name())andt.object_typeNOTIN(@part_sch,@assm,@tr,@ddltr)

        内容未完，下一页继续阅读

更多完整内容阅读登陆

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