How to change identity in asp.net C#/Vb.net behind code?
I will run scheudle task to change 1909000 to 1910000 on every month change
CREATE TABLE [dbo].[Courier] (
[Id] INT IDENTITY (1909000, 1) NOT NULL,
[Invoice] VARCHAR (MAX) NULL,
[Courier] VARCHAR (MAX) NULL,
[AWBNumber] VARCHAR (MAX) NULL,
[DispatchEmail] VARCHAR (MAX) NULL,
[DispatchFullDateTime] VARCHAR (MAX) NULL,
[DispatchDate] DATE NULL,
[DispatchTime] TIME NULL,
PRIMARY KEY CLUSTERED ([Id] ASC)
);