1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
|
create table #MesTables
(NOM_TABLE varchar(500),
DateCreation datetime null)
insert into #MesTables (NOM_TABLE)
select object_name(s.id)
FROM sys.sysobjects s
WHERE s.type = 'U'
declare crTbl cursor for select NOM_TABLE from #MesTables
declare @tbl varchar(500),
@req varchar(MAX)
open crTbl
fetch next from crTbl into @tbl
while @@fetch_status = 0
begin
set @req = 'update #MesTables set DateCreation = (select MAX(DateCreation) from ' + @tbl + ')'
exec (@req)
fetch next from crTbl into @tbl
end
close crTbl
deallocate crTbl
select * from #MesTables |