declare c cursor for select NAME from sysobjects where xtype=‘U‘ declare @t varchar(200) open c fetch next from c into @t while @@FETCH_STATUS=0 begin exec(‘truncate table ‘+@t) fetch next from c into @t end close c
2023-11-12 09:38:28
declare c cursor for select NAME from sysobjects where xtype=‘U‘ declare @t varchar(200) open c fetch next from c into @t while @@FETCH_STATUS=0 begin exec(‘truncate table ‘+@t) fetch next from c into @t end close c