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.
CREATE TABLE Client { clientId int IDENTITY(1,1) NOT NULL, Name VARCHAR(100) }
CREATE TABLE Nomination { NominationId UniqueIdentifier NOT NULL, NominationName VARCHAR(100) }
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.
RESEED
IDENTITY
uniqueidentifier
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)