SQL小技巧

2017-02-15 15:13:53
select number from master..spt_values where type='p' and number between 1 and 10
--下一个identity从9开始
DBCC CHECKIDENT (YourTableName, RESEED,8)