--MSSQL清空当前数据库中所有用户表的数据,重置标识列
declare @sql varchar(8000)
set @sql='' select @sql=@sql+' delete from ' + name + ' DBCC CHECKIDENT (' +name+ ',reseed,0)' from sysobjects where xtype = 'U'
execute (@sql)
--MSSQL清空当前数据库中所有用户表的数据,重置标识列
declare @sql varchar(8000)
set @sql='' select @sql=@sql+' delete from ' + name + ' DBCC CHECKIDENT (' +name+ ',reseed,0)' from sysobjects where xtype = 'U'
execute (@sql)