网上找到,参考:
序号从1开始
1.dbcc checkident('test',reseed,0) ///DXJ: 很牛!!
2.用生成脚本的方式
如
dbcc checkident('ks_article',reseed,0)
dbcc checkident('ks_photo',reseed,0)
dbcc checkident('ks_download',reseed,0)
dbcc checkident('ks_class',reseed,0)
dbcc checkident('ks_user',reseed,0)
dbcc checkident('KS_Blog',reseed,0)
dbcc checkident('KS_askzj',reseed,0)
dbcc checkident('KS_AskAnswer',reseed,0)
dbcc checkident('KS_ItemInfo',reseed,0)