既然不行 那就求一个SQl命令文件 每次我只要运行一下 就给我吧所有的表都执行了DBCC CHECKIDENT ("Alipay", RESEED, 38); @maxid=select max(aid) from a DBCC CHECKIDENT ("a", RESEED,@maxid); @maxid=select max(bid) from b DBCC CHECKIDENT ("b", RESEED,@maxid); @maxid=select max(cid) from c DBCC CHECKIDENT ("c", RESEED,@maxid); @maxid=select max(did) from d DBCC CHECKIDENT ("d", RESEED,@maxid);
DBCC CHECKIDENT ("a", RESEED,@maxid);
@maxid=select max(bid) from b
DBCC CHECKIDENT ("b", RESEED,@maxid);
@maxid=select max(cid) from c
DBCC CHECKIDENT ("c", RESEED,@maxid);
@maxid=select max(did) from d
DBCC CHECKIDENT ("d", RESEED,@maxid);