English 中文(简体)
如何获得自动生成列的下一个 ID
原标题:How to get the next ID of autogenerated column

在我表格 class 中,我有一个自动生成的列 ID 。在插入时,我想获取自动识别的值,这个值应该为该列生成,而插入和粘合到要放置在 reF 列中的值,这是一个6位数独有的密钥。

我怎样才能找到下列的 < code> ID , 在前一列 < code> ID 上添加 < code> 1 < /code > 很容易, 但如果删除前一代代代号, 则会怎样? 请帮助我了解如何解决这个问题 。

我不想将删除项目的 ID 给予新项目。

最佳回答

您可以使用 SCOPE_ IDENTIY () 来获取您当前范围中最后一个创建的身份值。 下一个值将会从中递增, 但是您不能确定它在您的范围、 其它范围或什么范围内。 删除不会影响下一个值是什么 。

你为什么需要"下一个价值"?

问题回答

暂无回答




相关问题
Anyone feel like passing it forward?

I m the only developer in my company, and am getting along well as an autodidact, but I know I m missing out on the education one gets from working with and having code reviewed by more senior devs. ...

How to Add script codes before the </body> tag ASP.NET

Heres the problem, In Masterpage, the google analytics code were pasted before the end of body tag. In ASPX page, I need to generate a script (google addItem tracker) using codebehind ClientScript ...

Transaction handling with TransactionScope

I am implementing Transaction using TransactionScope with the help this MSDN article http://msdn.microsoft.com/en-us/library/system.transactions.transactionscope.aspx I just want to confirm that is ...

System.Web.Mvc.Controller Initialize

i have the following base controller... public class BaseController : Controller { protected override void Initialize(System.Web.Routing.RequestContext requestContext) { if (...

Microsoft.Contracts namespace

For what it is necessary Microsoft.Contracts namespace in asp.net? I mean, in what cases I could write using Microsoft.Contracts;?

Separator line in ASP.NET

I d like to add a simple separator line in an aspx web form. Does anyone know how? It sounds easy enough, but still I can t manage to find how to do it.. 10x!

热门标签