SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE table1(
    secID INT NOT NULL IDENTITY(1, 1) PRIMARY KEY,
    docID INT,
    secName AS CONCAT('sec-', secID)
)
INSERT INTO table1 (docID) VALUES (11), (12), (13);

-- Let us create a hole in identity column
BEGIN TRANSACTION;
INSERT INTO table1 (docID) VALUES (14);
ROLLBACK;

INSERT INTO table1 (docID) VALUES (15);
5 rows affected

SELECT * FROM table1


secID
docID
secName


1
11
sec-1

2
12
sec-2

3
13
sec-3

5
15
sec-5