第239章你不会和星兽那个了吧 (4 / 7)
         SET @fullname = case when @objschema IS NULL then quotename(@objname)

         else quotename(@objschema) + '.' + quotename(@objname) end

         SET @objecttype = case when @objtype in (@uddt, @udt, @udtt) then 'TYPE'

         when @objtype = @xml then 'XML_SCHEMA_COLLECTION'

         when @objtype = @part_func then 'PARTITION_FUNCTION'

         else 'OBJECT' end

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

         select

         case dep.referencing_class when 1 then (select

         case when obj.type = 'U' then @u

         when obj.type = 'V' then @v

         when obj.type = 'TR' then @tr

         when obj.type in ('P', 'RF', 'PC') then @sp

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

更多完整内容阅读登陆

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