如果数据库表间没有关系,则直接删除: declare @sql varchar(8000) set @sql='' select @sql=@sql+char(13)+'go'+char(13)+'delete from '+name from sysobjects where xtype='U' and name<>'dtproperties' exec(@sql)否则删除语句必须要有顺序
EXEC sp_MSforeachtable @whereand='and exists(select * from sysobjects where xtype=''u'' and status>=0)', @command1='delete from ?'
pbsql(风云): 你能解释一下吗?我存储过程一点不懂,我要删除数据,不删除表?
就是写一些删除数据的SQL语句,如下: go delete from t1 go delete from t2 go delete from t3 ....然后执行
from sysobjects where xtype='U' and name<>'dtproperties',这是什么意思?
declare @sql varchar(8000)
set @sql=''
select @sql=@sql+char(13)+'go'+char(13)+'delete from '+name
from sysobjects where xtype='U' and name<>'dtproperties'
exec(@sql)否则删除语句必须要有顺序
@whereand='and exists(select * from sysobjects where xtype=''u'' and status>=0)',
@command1='delete from ?'
你能解释一下吗?我存储过程一点不懂,我要删除数据,不删除表?
go
delete from t1
go
delete from t2
go
delete from t3
....然后执行