declare @Platform nvarchar(100) = '库名'

declare @Platform_BusinessData nvarchar(100) = '库名' 

declare @LastModifyDate nvarchar(100) = '2017-02-16 00:00:00'  --修改时间

declare @sql nvarchar(max) = '

if OBJECT_ID(''tempdb..#t'') is not null drop table #t

select *

    into #t

    from (

    select ''' + @Platform + '..'' + o.name + isnull(''.'' + tb.name, '''') name, o.create_date, o.modify_date,o.type_desc

        FROM ' + @Platform + '.sys.all_objects o

        left join ' + @Platform + '.sys.triggers t on t.object_id = o.object_id

        left join ' + @Platform + '.sys.tables tb on tb.object_id = t.parent_id

        union all

    select ''' + @Platform_BusinessData + '..'' + o.name + isnull(''.'' + tb.name, ''''), o.create_date, o.modify_date,o.type_desc

        FROM ' + @Platform_BusinessData + '.sys.all_objects o

        left join ' + @Platform_BusinessData + '.sys.triggers t on t.object_id = o.object_id

        left join ' + @Platform_BusinessData + '.sys.tables tb on tb.object_id = t.parent_id

    ) t

    where modify_date >=''' + @LastModifyDate + '''

--select distinct type_desc from #t

select * from #t

    where type_desc = ''USER_TABLE''

        

select * from #t

    where type_desc = ''SQL_STORED_PROCEDURE''

    

select * from #t

    where type_desc = ''SQL_SCALAR_FUNCTION'' or type_desc = ''SQL_TABLE_VALUED_FUNCTION''

    

select * from #t

    where type_desc = ''VIEW''

    

select * from #t

    where type_desc = ''SQL_TRIGGER''

'    

print @Sql

exec sp_executesql @sql

-- select * from UBIPlatform..HY_SOLUTION where SolutionName like 'Case%' or SolutionName like '%Review'