declare @sql varchar(max) set @sql='' select @sql=@sql+'delete from '+name+';' from (select name from sysobjects where xtype='u' and name<>'USERS')t exec(@sql)
引用2楼,增加了防止保留字或特殊字符做表名declare @sql varchar(max) set @sql='' select @sql=@sql+'delete from ['+name+'];' from (select name from sysobjects where xtype='u' and name<>'USERS')t exec(@sql)
truncate table users
set @sql=''
select @sql=@sql+'delete from '+name+';'
from (select name from sysobjects where xtype='u' and name<>'USERS')t
exec(@sql)
set @sql=''
select @sql=@sql+'delete from ['+name+'];'
from (select name from sysobjects where xtype='u' and name<>'USERS')t
exec(@sql)