如何在uniqueidentifier领域实现RESEED概念

问题描述

Hi,

We have the tables in the below two formats. As per my business requirement,  I need to reseed table Id to 3 times of the current/maximum Id value using RESEED concept. I can achieve this for table1 but not for table2.

表-1：

Table-1:

CREATE TABLE Client
{
clientId int IDENTITY(1,1) NOT NULL,
Name VARCHAR(100)
}

表-2：

Table-2:

CREATE TABLE Nomination
{
NominationId UniqueIdentifier NOT NULL,
NominationName VARCHAR(100)
}

我尝试了什么：



我试图在表-2上应用重新设定的概念，但它没有用。

What I have tried:

I have tried to apply the reseed concept on table-2 but its not worked.

Is there any way to reserve Ids in three times of the current max Id for table2 without altering the current table structure from UniqueIdentifier  to identity field.

谢谢，

Sindhu

Thanks,
Sindhu

推荐答案

这篇关于如何在uniqueidentifier领域实现RESEED概念的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！