156 lines
14 KiB
SQL
156 lines
14 KiB
SQL
EXEC [dev].[uspCreateDictionaryItems] NULL, '2019/2020'
|
|
UPDATE DIB SET
|
|
DIB.C_NAME = N'Na', DIB.C_NAME_1 = N'Na', DIB.C_TYPE = N'Anyanyelv', DIB.C_PROTECTED = N'T', DIB.C_ORDER = 1
|
|
FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.TOROLT = 'F' AND t.C_NEV = '2019/2020' WHERE DIB.ID = 493;
|
|
UPDATE DIB SET
|
|
DIB.C_NAME = N'magyar', DIB.C_NAME_1 = N'Hungarian', DIB.C_TYPE = N'Anyanyelv', DIB.C_PROTECTED = N'T', DIB.C_ORDER = 2
|
|
FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.TOROLT = 'F' AND t.C_NEV = '2019/2020' WHERE DIB.ID = 509;
|
|
UPDATE DIB SET
|
|
DIB.C_NAME = N'afgán', DIB.C_NAME_1 = N'Afghan', DIB.C_TYPE = N'Anyanyelv', DIB.C_PROTECTED = N'T', DIB.C_ORDER = 10
|
|
FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.TOROLT = 'F' AND t.C_NEV = '2019/2020' WHERE DIB.ID = 494;
|
|
UPDATE DIB SET
|
|
DIB.C_NAME = N'albán', DIB.C_NAME_1 = N'Albanian', DIB.C_TYPE = N'Anyanyelv', DIB.C_PROTECTED = N'T', DIB.C_ORDER = 20
|
|
FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.TOROLT = 'F' AND t.C_NEV = '2019/2020' WHERE DIB.ID = 495;
|
|
UPDATE DIB SET
|
|
DIB.C_NAME = N'angol', DIB.C_NAME_1 = N'Angol', DIB.C_TYPE = N'Anyanyelv', DIB.C_PROTECTED = N'T', DIB.C_ORDER = 30
|
|
FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.TOROLT = 'F' AND t.C_NEV = '2019/2020' WHERE DIB.ID = 534;
|
|
UPDATE DIB SET
|
|
DIB.C_NAME = N'arab', DIB.C_NAME_1 = N'Arab', DIB.C_TYPE = N'Anyanyelv', DIB.C_PROTECTED = N'T', DIB.C_ORDER = 40
|
|
FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.TOROLT = 'F' AND t.C_NEV = '2019/2020' WHERE DIB.ID = 530;
|
|
UPDATE DIB SET
|
|
DIB.C_NAME = N'azeri', DIB.C_NAME_1 = N'Azeri', DIB.C_TYPE = N'Anyanyelv', DIB.C_PROTECTED = N'T', DIB.C_ORDER = 50
|
|
FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.TOROLT = 'F' AND t.C_NEV = '2019/2020' WHERE DIB.ID = 496;
|
|
UPDATE DIB SET
|
|
DIB.C_NAME = N'bolgár', DIB.C_NAME_1 = N'Bulgarian', DIB.C_TYPE = N'Anyanyelv', DIB.C_PROTECTED = N'T', DIB.C_ORDER = 60
|
|
FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.TOROLT = 'F' AND t.C_NEV = '2019/2020' WHERE DIB.ID = 498;
|
|
UPDATE DIB SET
|
|
DIB.C_NAME = N'cseh', DIB.C_NAME_1 = N'Czech', DIB.C_TYPE = N'Anyanyelv', DIB.C_PROTECTED = N'T', DIB.C_ORDER = 70
|
|
FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.TOROLT = 'F' AND t.C_NEV = '2019/2020' WHERE DIB.ID = 501;
|
|
UPDATE DIB SET
|
|
DIB.C_NAME = N'dán', DIB.C_NAME_1 = N'Danish', DIB.C_TYPE = N'Anyanyelv', DIB.C_PROTECTED = N'T', DIB.C_ORDER = 80
|
|
FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.TOROLT = 'F' AND t.C_NEV = '2019/2020' WHERE DIB.ID = 502;
|
|
UPDATE DIB SET
|
|
DIB.C_NAME = N'egyéb', DIB.C_NAME_1 = N'Egyéb', DIB.C_TYPE = N'Anyanyelv', DIB.C_PROTECTED = N'T', DIB.C_ORDER = 90
|
|
FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.TOROLT = 'F' AND t.C_NEV = '2019/2020' WHERE DIB.ID = 542;
|
|
UPDATE DIB SET
|
|
DIB.C_NAME = N'eszperanto', DIB.C_NAME_1 = N'Eszperanto', DIB.C_TYPE = N'Anyanyelv', DIB.C_PROTECTED = N'T', DIB.C_ORDER = 100
|
|
FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.TOROLT = 'F' AND t.C_NEV = '2019/2020' WHERE DIB.ID = 537;
|
|
UPDATE DIB SET
|
|
DIB.C_NAME = N'észt', DIB.C_NAME_1 = N'Esthonian', DIB.C_TYPE = N'Anyanyelv', DIB.C_PROTECTED = N'T', DIB.C_ORDER = 110
|
|
FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.TOROLT = 'F' AND t.C_NEV = '2019/2020' WHERE DIB.ID = 503;
|
|
UPDATE DIB SET
|
|
DIB.C_NAME = N'finn', DIB.C_NAME_1 = N'Finn', DIB.C_TYPE = N'Anyanyelv', DIB.C_PROTECTED = N'T', DIB.C_ORDER = 120
|
|
FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.TOROLT = 'F' AND t.C_NEV = '2019/2020' WHERE DIB.ID = 504;
|
|
UPDATE DIB SET
|
|
DIB.C_NAME = N'francia', DIB.C_NAME_1 = N'French', DIB.C_TYPE = N'Anyanyelv', DIB.C_PROTECTED = N'T', DIB.C_ORDER = 130
|
|
FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.TOROLT = 'F' AND t.C_NEV = '2019/2020' WHERE DIB.ID = 505;
|
|
UPDATE DIB SET
|
|
DIB.C_NAME = N'görög', DIB.C_NAME_1 = N'Greek', DIB.C_TYPE = N'Anyanyelv', DIB.C_PROTECTED = N'T', DIB.C_ORDER = 140
|
|
FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.TOROLT = 'F' AND t.C_NEV = '2019/2020' WHERE DIB.ID = 508;
|
|
UPDATE DIB SET
|
|
DIB.C_NAME = N'grúz', DIB.C_NAME_1 = N'Georgian', DIB.C_TYPE = N'Anyanyelv', DIB.C_PROTECTED = N'T', DIB.C_ORDER = 150
|
|
FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.TOROLT = 'F' AND t.C_NEV = '2019/2020' WHERE DIB.ID = 506;
|
|
UPDATE DIB SET
|
|
DIB.C_NAME = N'héber', DIB.C_NAME_1 = N'Héber', DIB.C_TYPE = N'Anyanyelv', DIB.C_PROTECTED = N'T', DIB.C_ORDER = 160
|
|
FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.TOROLT = 'F' AND t.C_NEV = '2019/2020' WHERE DIB.ID = 512;
|
|
UPDATE DIB SET
|
|
DIB.C_NAME = N'hindi', DIB.C_NAME_1 = N'Hindi', DIB.C_TYPE = N'Anyanyelv', DIB.C_PROTECTED = N'T', DIB.C_ORDER = 170
|
|
FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.TOROLT = 'F' AND t.C_NEV = '2019/2020' WHERE DIB.ID = 510;
|
|
UPDATE DIB SET
|
|
DIB.C_NAME = N'holland', DIB.C_NAME_1 = N'Dutch', DIB.C_TYPE = N'Anyanyelv', DIB.C_PROTECTED = N'T', DIB.C_ORDER = 180
|
|
FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.TOROLT = 'F' AND t.C_NEV = '2019/2020' WHERE DIB.ID = 519;
|
|
UPDATE DIB SET
|
|
DIB.C_NAME = N'horvát', DIB.C_NAME_1 = N'Croatian', DIB.C_TYPE = N'Anyanyelv', DIB.C_PROTECTED = N'T', DIB.C_ORDER = 190
|
|
FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.TOROLT = 'F' AND t.C_NEV = '2019/2020' WHERE DIB.ID = 500;
|
|
UPDATE DIB SET
|
|
DIB.C_NAME = N'japán', DIB.C_NAME_1 = N'Japanese', DIB.C_TYPE = N'Anyanyelv', DIB.C_PROTECTED = N'T', DIB.C_ORDER = 210
|
|
FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.TOROLT = 'F' AND t.C_NEV = '2019/2020' WHERE DIB.ID = 514;
|
|
UPDATE DIB SET
|
|
DIB.C_NAME = N'kazah', DIB.C_NAME_1 = N'Kazakh', DIB.C_TYPE = N'Anyanyelv', DIB.C_PROTECTED = N'T', DIB.C_ORDER = 220
|
|
FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.TOROLT = 'F' AND t.C_NEV = '2019/2020' WHERE DIB.ID = 539;
|
|
UPDATE DIB SET
|
|
DIB.C_NAME = N'kikuju (kenya)', DIB.C_NAME_1 = N'Kikuju (kenya)', DIB.C_TYPE = N'Anyanyelv', DIB.C_PROTECTED = N'T', DIB.C_ORDER = 230
|
|
FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.TOROLT = 'F' AND t.C_NEV = '2019/2020' WHERE DIB.ID = 541;
|
|
UPDATE DIB SET
|
|
DIB.C_NAME = N'kínai', DIB.C_NAME_1 = N'Chinese', DIB.C_TYPE = N'Anyanyelv', DIB.C_PROTECTED = N'T', DIB.C_ORDER = 240
|
|
FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.TOROLT = 'F' AND t.C_NEV = '2019/2020' WHERE DIB.ID = 499;
|
|
UPDATE DIB SET
|
|
DIB.C_NAME = N'koreai', DIB.C_NAME_1 = N'Korean', DIB.C_TYPE = N'Anyanyelv', DIB.C_PROTECTED = N'T', DIB.C_ORDER = 250
|
|
FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.TOROLT = 'F' AND t.C_NEV = '2019/2020' WHERE DIB.ID = 515;
|
|
UPDATE DIB SET
|
|
DIB.C_NAME = N'latin', DIB.C_NAME_1 = N'Latin', DIB.C_TYPE = N'Anyanyelv', DIB.C_PROTECTED = N'T', DIB.C_ORDER = 260
|
|
FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.TOROLT = 'F' AND t.C_NEV = '2019/2020' WHERE DIB.ID = 538;
|
|
UPDATE DIB SET
|
|
DIB.C_NAME = N'lengyel', DIB.C_NAME_1 = N'Polish', DIB.C_TYPE = N'Anyanyelv', DIB.C_PROTECTED = N'T', DIB.C_ORDER = 270
|
|
FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.TOROLT = 'F' AND t.C_NEV = '2019/2020' WHERE DIB.ID = 521;
|
|
UPDATE DIB SET
|
|
DIB.C_NAME = N'lett', DIB.C_NAME_1 = N'Latvian', DIB.C_TYPE = N'Anyanyelv', DIB.C_PROTECTED = N'T', DIB.C_ORDER = 280
|
|
FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.TOROLT = 'F' AND t.C_NEV = '2019/2020' WHERE DIB.ID = 516;
|
|
UPDATE DIB SET
|
|
DIB.C_NAME = N'litván', DIB.C_NAME_1 = N'Lithuanian', DIB.C_TYPE = N'Anyanyelv', DIB.C_PROTECTED = N'T', DIB.C_ORDER = 290
|
|
FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.TOROLT = 'F' AND t.C_NEV = '2019/2020' WHERE DIB.ID = 517;
|
|
UPDATE DIB SET
|
|
DIB.C_NAME = N'macedón', DIB.C_NAME_1 = N'Macedonian', DIB.C_TYPE = N'Anyanyelv', DIB.C_PROTECTED = N'T', DIB.C_ORDER = 300
|
|
FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.TOROLT = 'F' AND t.C_NEV = '2019/2020' WHERE DIB.ID = 533;
|
|
UPDATE DIB SET
|
|
DIB.C_NAME = N'mongol', DIB.C_NAME_1 = N'Mongolian', DIB.C_TYPE = N'Anyanyelv', DIB.C_PROTECTED = N'T', DIB.C_ORDER = 310
|
|
FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.TOROLT = 'F' AND t.C_NEV = '2019/2020' WHERE DIB.ID = 518;
|
|
UPDATE DIB SET
|
|
DIB.C_NAME = N'német', DIB.C_NAME_1 = N'German', DIB.C_TYPE = N'Anyanyelv', DIB.C_PROTECTED = N'T', DIB.C_ORDER = 320
|
|
FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.TOROLT = 'F' AND t.C_NEV = '2019/2020' WHERE DIB.ID = 507;
|
|
UPDATE DIB SET
|
|
DIB.C_NAME = N'norvég', DIB.C_NAME_1 = N'Norwegian', DIB.C_TYPE = N'Anyanyelv', DIB.C_PROTECTED = N'T', DIB.C_ORDER = 330
|
|
FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.TOROLT = 'F' AND t.C_NEV = '2019/2020' WHERE DIB.ID = 520;
|
|
UPDATE DIB SET
|
|
DIB.C_NAME = N'olasz', DIB.C_NAME_1 = N'Italian', DIB.C_TYPE = N'Anyanyelv', DIB.C_PROTECTED = N'T', DIB.C_ORDER = 340
|
|
FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.TOROLT = 'F' AND t.C_NEV = '2019/2020' WHERE DIB.ID = 513;
|
|
UPDATE DIB SET
|
|
DIB.C_NAME = N'örmény', DIB.C_NAME_1 = N'Armenian', DIB.C_TYPE = N'Anyanyelv', DIB.C_PROTECTED = N'T', DIB.C_ORDER = 350
|
|
FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.TOROLT = 'F' AND t.C_NEV = '2019/2020' WHERE DIB.ID = 497;
|
|
UPDATE DIB SET
|
|
DIB.C_NAME = N'orosz', DIB.C_NAME_1 = N'Russian', DIB.C_TYPE = N'Anyanyelv', DIB.C_PROTECTED = N'T', DIB.C_ORDER = 360
|
|
FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.TOROLT = 'F' AND t.C_NEV = '2019/2020' WHERE DIB.ID = 524;
|
|
UPDATE DIB SET
|
|
DIB.C_NAME = N'perzsa', DIB.C_NAME_1 = N'Perzsa', DIB.C_TYPE = N'Anyanyelv', DIB.C_PROTECTED = N'T', DIB.C_ORDER = 370
|
|
FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.TOROLT = 'F' AND t.C_NEV = '2019/2020' WHERE DIB.ID = 511;
|
|
UPDATE DIB SET
|
|
DIB.C_NAME = N'portugál', DIB.C_NAME_1 = N'Portugese', DIB.C_TYPE = N'Anyanyelv', DIB.C_PROTECTED = N'T', DIB.C_ORDER = 380
|
|
FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.TOROLT = 'F' AND t.C_NEV = '2019/2020' WHERE DIB.ID = 522;
|
|
UPDATE DIB SET
|
|
DIB.C_NAME = N'román', DIB.C_NAME_1 = N'Romanian', DIB.C_TYPE = N'Anyanyelv', DIB.C_PROTECTED = N'T', DIB.C_ORDER = 390
|
|
FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.TOROLT = 'F' AND t.C_NEV = '2019/2020' WHERE DIB.ID = 523;
|
|
UPDATE DIB SET
|
|
DIB.C_NAME = N'spanyol', DIB.C_NAME_1 = N'Spanish', DIB.C_TYPE = N'Anyanyelv', DIB.C_PROTECTED = N'T', DIB.C_ORDER = 400
|
|
FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.TOROLT = 'F' AND t.C_NEV = '2019/2020' WHERE DIB.ID = 527;
|
|
UPDATE DIB SET
|
|
DIB.C_NAME = N'svéd', DIB.C_NAME_1 = N'Swedish', DIB.C_TYPE = N'Anyanyelv', DIB.C_PROTECTED = N'T', DIB.C_ORDER = 410
|
|
FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.TOROLT = 'F' AND t.C_NEV = '2019/2020' WHERE DIB.ID = 528;
|
|
UPDATE DIB SET
|
|
DIB.C_NAME = N'szerb', DIB.C_NAME_1 = N'Serb', DIB.C_TYPE = N'Anyanyelv', DIB.C_PROTECTED = N'T', DIB.C_ORDER = 420
|
|
FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.TOROLT = 'F' AND t.C_NEV = '2019/2020' WHERE DIB.ID = 536;
|
|
UPDATE DIB SET
|
|
DIB.C_NAME = N'szlovák', DIB.C_NAME_1 = N'Slovak', DIB.C_TYPE = N'Anyanyelv', DIB.C_PROTECTED = N'T', DIB.C_ORDER = 430
|
|
FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.TOROLT = 'F' AND t.C_NEV = '2019/2020' WHERE DIB.ID = 525;
|
|
UPDATE DIB SET
|
|
DIB.C_NAME = N'szlovén', DIB.C_NAME_1 = N'Slovene', DIB.C_TYPE = N'Anyanyelv', DIB.C_PROTECTED = N'T', DIB.C_ORDER = 440
|
|
FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.TOROLT = 'F' AND t.C_NEV = '2019/2020' WHERE DIB.ID = 526;
|
|
UPDATE DIB SET
|
|
DIB.C_NAME = N'thai', DIB.C_NAME_1 = N'Thai', DIB.C_TYPE = N'Anyanyelv', DIB.C_PROTECTED = N'T', DIB.C_ORDER = 450
|
|
FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.TOROLT = 'F' AND t.C_NEV = '2019/2020' WHERE DIB.ID = 529;
|
|
UPDATE DIB SET
|
|
DIB.C_NAME = N'török', DIB.C_NAME_1 = N'Turkish', DIB.C_TYPE = N'Anyanyelv', DIB.C_PROTECTED = N'T', DIB.C_ORDER = 460
|
|
FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.TOROLT = 'F' AND t.C_NEV = '2019/2020' WHERE DIB.ID = 531;
|
|
UPDATE DIB SET
|
|
DIB.C_NAME = N'ukrán', DIB.C_NAME_1 = N'Ukrán', DIB.C_TYPE = N'Anyanyelv', DIB.C_PROTECTED = N'T', DIB.C_ORDER = 470
|
|
FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.TOROLT = 'F' AND t.C_NEV = '2019/2020' WHERE DIB.ID = 532;
|
|
UPDATE DIB SET
|
|
DIB.C_NAME = N'üzbég', DIB.C_NAME_1 = N'Üzbég', DIB.C_TYPE = N'Anyanyelv', DIB.C_PROTECTED = N'T', DIB.C_ORDER = 480
|
|
FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.TOROLT = 'F' AND t.C_NEV = '2019/2020' WHERE DIB.ID = 535;
|
|
UPDATE DIB SET
|
|
DIB.C_NAME = N'vietnami', DIB.C_NAME_1 = N'Vietnami', DIB.C_TYPE = N'Anyanyelv', DIB.C_PROTECTED = N'T', DIB.C_ORDER = 490
|
|
FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.TOROLT = 'F' AND t.C_NEV = '2019/2020' WHERE DIB.ID = 540;
|
|
UPDATE DIB SET
|
|
DIB.C_NAME = N'ismeretlen', DIB.C_NAME_1 = N'Unknown', DIB.C_TYPE = N'Anyanyelv', DIB.C_PROTECTED = N'T', DIB.C_ORDER = 1000
|
|
FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.TOROLT = 'F' AND t.C_NEV = '2019/2020' WHERE DIB.ID = 3031;
|
|
|
|
EXEC [dev].uspSwitchDictionaryItemBaseFromTmp |