Create Procedure TruncateAll AS declare @name varchar(100), @sqlstr varchar(500) declare clear_cursor cursor for select name from sysobjects where xtype='U' and name<>'dtproperties' open Clear_cursor fetch next from Clear_cursor into @name while @@fetch_status=0 begin select @sqlstr='truncate table '+@name exec(@sqlstr) fetch next from Clear_cursor into @name end close clear_cursor deallocate clear_cursor
AS
declare @name varchar(100),
@sqlstr varchar(500)
declare clear_cursor cursor for select name from sysobjects where xtype='U' and name<>'dtproperties'
open Clear_cursor
fetch next from Clear_cursor into @name
while @@fetch_status=0
begin
select @sqlstr='truncate table '+@name
exec(@sqlstr)
fetch next from Clear_cursor into @name
end
close clear_cursor
deallocate clear_cursor