本文介绍了如何按顺序获取标识列值的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
某些连续的vales被删除我想使用那些值
some sequential vales are deleted i want to use those values
推荐答案你不能,暂时禁用身份 - 如果你在多用户环境?如果两个人决定同时重新使用旧号码,你可能会回来同样的问题,你试图使用身份字段来避免.... 如果你需要一个反映记录数量中行位置的数字,那么使用ROW_NUMBER函数: You can''t, without disabling the identity temporarily - and what if you are in a multiuser environment? If two people decide to re-use the old number at the same time, you could be back with teh same problem you are trying to use identity fields to avoid.... If you need a number which reflects a rows position in the number of records, then use the ROW_NUMBER function: SELECT Id, Customer, date, Value, @@ROWCOUNT as 'Row Count', ROW_NUMBER() OVER (ORDER BY Id) AS 'Row Number' FROM Customers
这会随着您插入和删除记录而有所不同,但身份值可以保留安全而独特。
That will vary as you insert and remove records, but the identity value can remain safe and unique.
更多推荐
如何按顺序获取标识列值
发布评论