SQL Server 2022

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

create FUNCTION [dbo].ean13Uret (
    @firmaKodu VARCHAR(7), 
    @baslangicNo INT, 
    @uretilecekAdet INT
)
RETURNS @BarkodListesi TABLE (
    SiraNo INT,
    Barkod VARCHAR(13)
)
AS
BEGIN
    DECLARE @i INT = 0;
    DECLARE @barkod VARCHAR(12);
    DECLARE @tamBarkod VARCHAR(13);
    DECLARE @baslangic INT = @baslangicNo;

WHILE @i < @uretilecekAdet
    BEGIN
        -- Barkodun ilk 12 hanesi (firma kodu + seri numarası)
        SET @barkod = CONCAT(@firmaKodu, RIGHT(CONCAT('00000', CAST(@baslangic AS VARCHAR(5))), 5))

-- Kontrol hanesi hesapla
        DECLARE @toplam INTEGER = 
            1 * CAST(SUBSTRING(@barkod, 1, 1) AS INTEGER) +
            3 * CAST(SUBSTRING(@barkod, 2, 1) AS INTEGER) +
            1 * CAST(SUBSTRING(@barkod, 3, 1) AS INTEGER) +
            3 * CAST(SUBSTRING(@barkod, 4, 1) AS INTEGER) +
            1 * CAST(SUBSTRING(@barkod, 5, 1) AS INTEGER) +
            3 * CAST(SUBSTRING(@barkod, 6, 1) AS INTEGER) +
            1 * CAST(SUBSTRING(@barkod, 7, 1) AS INTEGER) +
            3 * CAST(SUBSTRING(@barkod, 8, 1) AS INTEGER) +
            1 * CAST(SUBSTRING(@barkod, 9, 1) AS INTEGER) +
            3 * CAST(SUBSTRING(@barkod,10, 1) AS INTEGER) +
            1 * CAST(SUBSTRING(@barkod,11, 1) AS INTEGER) +
            3 * CAST(SUBSTRING(@barkod,12, 1) AS INTEGER);

DECLARE @kontrolHanesi INTEGER = (10 - (@toplam % 10)) % 10

-- Tam barkod (12 hane + kontrol hanesi)
        SET @tamBarkod = CONCAT(@barkod, CAST(@kontrolHanesi AS VARCHAR(1)))

-- Barkodu geçic tabloya ekle
        INSERT INTO @BarkodListesi (SiraNo, Barkod) VALUES (@i + 1, @tamBarkod)

-- Sonraki barkoda geç
        SET @baslangic = @baslangic + 1
        SET @i = @i + 1
    END

-- tabloyu döndür
    RETURN
END

SiraNo	Barkod
1	8690000000586
2	8690000000593
3	8690000000609
4	8690000000616
5	8690000000623
6	8690000000630
7	8690000000647
8	8690000000654
9	8690000000661
10	8690000000678
11	8690000000685
12	8690000000692
13	8690000000708
14	8690000000715
15	8690000000722
16	8690000000739
17	8690000000746
18	8690000000753
19	8690000000760
20	8690000000777