SQL小技巧
2017-02-15 15:13:53- 获取连续数字集合
select number from master..spt_values where type='p' and number between 1 and 10
- 重置identity
--下一个identity从9开始
DBCC CHECKIDENT (YourTableName, RESEED,8)
select number from master..spt_values where type='p' and number between 1 and 10
--下一个identity从9开始
DBCC CHECKIDENT (YourTableName, RESEED,8)