原文地址:http://www.sqlservercentral.com/scripts/T-SQL/61216/
清除表的数据脚本如下:
EXECUTE sp_msforeachtable 'delete from ?'
EXECUTE sp_msforeachtable 'print "?" dbcc checkident ("?", RESEED, 1)'
以上代码不说大家也清楚
原文地址:http://www.sqlservercentral.com/scripts/T-SQL/61216/
清除表的数据脚本如下:
EXECUTE sp_msforeachtable 'delete from ?'
EXECUTE sp_msforeachtable 'print "?" dbcc checkident ("?", RESEED, 1)'
以上代码不说大家也清楚