SQL Server 2017

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

CREATE SEQUENCE MySequence
AS int
START WITH 1
INCREMENT BY 1;
CREATE TABLE Complaint
(
    Id char(8) CONSTRAINT [DF_Complaint_ID]
                      DEFAULT FORMAT((NEXT VALUE FOR MySequence), '0000#')
                      +'/'+RIGHT(YEAR(GETDATE()),2),
    Foo   int,
    Bar   int,
    
    CONSTRAINT [PK_MyTable] PRIMARY KEY (Id)
);
declare @i int
set @i=1

while @i<20
begin
INSERT INTO Complaint (Foo, Bar) VALUES (@i, @i);  
set @i=@i+1
end
19 rows affected

SELECT * FROM Complaint;


Id
Foo
Bar


00001/23
1
1

00002/23
2
2

00003/23
3
3

00004/23
4
4

00005/23
5
5

00006/23
6
6

00007/23
7
7

00008/23
8
8

00009/23
9
9

00010/23
10
10

00011/23
11
11

00012/23
12
12

00013/23
13
13

00014/23
14
14

00015/23
15
15

00016/23
16
16

00017/23
17
17

00018/23
18
18

00019/23
19
19

Id	Foo	Bar
00001/23	1	1
00002/23	2	2
00003/23	3	3
00004/23	4	4
00005/23	5	5
00006/23	6	6
00007/23	7	7
00008/23	8	8
00009/23	9	9
00010/23	10	10
00011/23	11	11
00012/23	12	12
00013/23	13	13
00014/23	14	14
00015/23	15	15
00016/23	16	16
00017/23	17	17
00018/23	18	18
00019/23	19	19