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)