删除数据库所有表的数据
declare @str varchar(8000)
set @str= ' '
select @str=@str+ 'truncate table '+name+char(10) from sysobjects where xtype= 'U '
exec(@str)
set @str= ' '
select @str=@str+ 'truncate table '+name+char(10) from sysobjects where xtype= 'U '
exec(@str)