Emad's Blog

The following script will insert Languages in a Languages lookup table.

The script is assuming SQL server where the ID is an Identity column.

The Table Languages has two columns (“ID” (identity) and “Language” (varchar))
INSERT INTO [Languages]([Language])VALUES(‘African’);
INSERT INTO [Languages]([Language])VALUES(‘Albanian’);
INSERT INTO [Languages]([Language])VALUES(‘Arabic’);
INSERT INTO [Languages]([Language])VALUES(‘Armenian’);
INSERT INTO [Languages]([Language])VALUES(‘Belarusian’);
INSERT INTO [Languages]([Language])VALUES(‘Bosnian’);
INSERT INTO [Languages]([Language])VALUES(‘Bulgarian’);
INSERT INTO [Languages]([Language])VALUES(‘Cantonese’);
INSERT INTO [Languages]([Language])VALUES(‘Catalan’);
INSERT INTO [Languages]([Language])VALUES(‘Czech’);
INSERT INTO [Languages]([Language])VALUES(‘Danish’);
INSERT INTO [Languages]([Language])VALUES(‘Dutch’);
INSERT INTO [Languages]([Language])VALUES(‘English’);
INSERT INTO [Languages]([Language])VALUES(‘Estonian’);
INSERT INTO [Languages]([Language])VALUES(‘Farsi’);
INSERT INTO [Languages]([Language])VALUES(‘Finnish’);
INSERT INTO [Languages]([Language])VALUES(‘Flemish’);
INSERT INTO [Languages]([Language])VALUES(‘French’);
INSERT INTO [Languages]([Language])VALUES(‘Gaelic’);
INSERT INTO [Languages]([Language])VALUES(‘German’);
INSERT INTO [Languages]([Language])VALUES(‘Greek’);
INSERT INTO [Languages]([Language])VALUES(‘Gujarati’);
INSERT INTO [Languages]([Language])VALUES(‘Hebrew’);
INSERT INTO [Languages]([Language])VALUES(‘Hindi’);
INSERT INTO [Languages]([Language])VALUES(‘Hungarian’);
INSERT INTO [Languages]([Language])VALUES(‘Icelandic’);
INSERT INTO [Languages]([Language])VALUES(‘Indonesian’);
INSERT INTO [Languages]([Language])VALUES(‘Italian’);
INSERT INTO [Languages]([Language])VALUES(‘Japanese’);
INSERT INTO [Languages]([Language])VALUES(‘Korean’);
INSERT INTO [Languages]([Language])VALUES(‘Latvian’);
INSERT INTO [Languages]([Language])VALUES(‘Lithuanian’);
INSERT INTO [Languages]([Language])VALUES(‘Luxembourgeois’);
INSERT INTO [Languages]([Language])VALUES(‘Macedonian’);
INSERT INTO [Languages]([Language])VALUES(‘Malaysian’);
INSERT INTO [Languages]([Language])VALUES(‘Mandarin’);
INSERT INTO [Languages]([Language])VALUES(‘Norwegian’);
INSERT INTO [Languages]([Language])VALUES(‘Polish’);
INSERT INTO [Languages]([Language])VALUES(‘Portuguese’);
INSERT INTO [Languages]([Language])VALUES(‘Punjabi’);
INSERT INTO [Languages]([Language])VALUES(‘Romanian’);
INSERT INTO [Languages]([Language])VALUES(‘Russian’);
INSERT INTO [Languages]([Language])VALUES(‘Serbian’);
INSERT INTO [Languages]([Language])VALUES(‘Serbian’);
INSERT INTO [Languages]([Language])VALUES(‘Slovak’);
INSERT INTO [Languages]([Language])VALUES(‘Slovenian’);
INSERT INTO [Languages]([Language])VALUES(‘Spanish’);
INSERT INTO [Languages]([Language])VALUES(‘Swedish’);
INSERT INTO [Languages]([Language])VALUES(‘Swiss French’);
INSERT INTO [Languages]([Language])VALUES(‘Swiss German’);
INSERT INTO [Languages]([Language])VALUES(‘Tamil’);
INSERT INTO [Languages]([Language])VALUES(‘Thai’);
INSERT INTO [Languages]([Language])VALUES(‘Turkish’);
INSERT INTO [Languages]([Language])VALUES(‘Ukrainian’);
INSERT INTO [Languages]([Language])VALUES(‘Urdu’);
INSERT INTO [Languages]([Language])VALUES(‘Welsh’);