Skip to content

Instantly share code, notes, and snippets.

@Orbis25

Orbis25/auto-increment-code.sql

Created March 23, 2023 20:22
Show Gist options
  • Save Orbis25/962d2e9edd9eb28df28019aceb96b3b5 to your computer and use it in GitHub Desktop.
Save Orbis25/962d2e9edd9eb28df28019aceb96b3b5 to your computer and use it in GitHub Desktop.
Download ZIP
Generate a unique code in sql autoincrement
Raw
auto-increment-code.sql
CREATE TABLE [TABLE_NAME](
Id UNIQUEIDENTIFIER PRIMARY KEY NOT NULL,
[Index] INT IDENTITY(1,1) NOT NULL,
[Code] AS ('P'+ RIGHT('00000' + CAST(([Index]) AS VARCHAR(5)), 5)) PERSISTED,
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment