Feeds:
Posts
Comments

Posts Tagged ‘Scripts’

Many times we need a script that reproduces a database schema along with some data; example: lookup tables values.

Turned out it can be done quite easily with the Publishing wizard that is a standard part of the Visual studio 2008.

All you need to do is open the database in the server explorer, right click on the database and select “Publish to provider”.

Screen shot

PublishDB

Read Full Post »

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

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

The Table Countries has two columns (“ID” (identity) and “Country” (varchar))

=======================

INSERT INTO COUNTRIES(NAME) VALUES(‘Afghanistan’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Albania’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Algeria’);
INSERT INTO COUNTRIES(NAME) VALUES(‘American Samoa’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Andorra’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Angola’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Anguilla’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Antarctica’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Antigua and Barbuda’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Argentina’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Armenia’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Aruba’);
INSERT INTO COUNTRIES(NAME) VALUES(‘ustralia’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Austria’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Azerbaijan’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Bahamas’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Bahrain’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Bangladesh’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Barbados’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Belarus ‘);
INSERT INTO COUNTRIES(NAME) VALUES(‘Belgium ‘);
INSERT INTO COUNTRIES(NAME) VALUES(‘Belize’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Benin’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Bermuda’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Bhutan’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Bolivia’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Bosnia and Herzegowina’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Botswana’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Bouvet Island’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Brazil’);
INSERT INTO COUNTRIES(NAME) VALUES(‘British Indian Ocean’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Brunei Darussalam’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Bulgaria’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Burkina Faso ‘);
INSERT INTO COUNTRIES(NAME) VALUES(‘Burundi’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Cambodia ‘);
INSERT INTO COUNTRIES(NAME) VALUES(‘Cameroon ‘);
INSERT INTO COUNTRIES(NAME) VALUES(‘anada’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Cape Verde’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Cayman Islands’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Central African Republic’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Chad’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Chile’);
INSERT INTO COUNTRIES(NAME) VALUES(‘China’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Christmas Island’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Cocos (Keeling) Islands’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Colombia’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Comoros’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Congo (Democratic Republic of the)’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Congo (Republic of the)’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Cook islands’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Costa Rica’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Cote dIvoire (Ivory Coast)’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Croatia’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Cuba’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Curaco’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Cyprus’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Cyprus (Turkish Republic of Northern)’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Czech Republic’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Denmark’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Djibouti ‘);
INSERT INTO COUNTRIES(NAME) VALUES(‘Dominica’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Dominican Republic’);
INSERT INTO COUNTRIES(NAME) VALUES(‘East Timor’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Ecuador’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Egypt’);
INSERT INTO COUNTRIES(NAME) VALUES(‘El Salvador’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Equatorial Guinea’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Eritrea’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Estonia’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Ethiopia’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Falkland Islands’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Faroe Islands’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Fiji’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Finland’);
INSERT INTO COUNTRIES(NAME) VALUES(‘France’);
INSERT INTO COUNTRIES(NAME) VALUES(‘France, Metropolitan’);
INSERT INTO COUNTRIES(NAME) VALUES(‘French Guiana ‘);
INSERT INTO COUNTRIES(NAME) VALUES(‘French Polynesia’);
INSERT INTO COUNTRIES(NAME) VALUES(‘French Southern Territories’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Gabon’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Gambia’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Georgia’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Germany ‘);
INSERT INTO COUNTRIES(NAME) VALUES(‘Ghana’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Gibraltar’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Greece’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Greenland’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Grenada’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Guadeloupe’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Guam’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Guatemala’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Guinea’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Guinea-Bissau’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Guyana’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Haiti’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Heard and Mc Donald Islands’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Honduras’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Hong Kong’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Hungary’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Iceland’);
INSERT INTO COUNTRIES(NAME) VALUES(‘India’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Indonesia’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Iran’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Iraq ‘);
INSERT INTO COUNTRIES(NAME) VALUES(‘Ireland’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Israel’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Italy’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Jamaica’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Japan’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Jordan’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Kazakhstan’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Kenya’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Kiribati ‘);
INSERT INTO COUNTRIES(NAME) VALUES(‘Korea, Republic of (south)’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Kosovo’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Kuwait’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Kyrgyzstan’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Laos (Lao Peoples Democratic Republic)’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Latvia’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Lebanon’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Lesotho’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Liberia’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Libyan Arab Jamahiriya’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Liechtenstein’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Lithuania’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Luxembourg’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Macau’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Macedonia’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Madagascar’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Malawi’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Malaysia’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Maldives’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Mali’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Malta’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Marshall Islands’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Martinique ‘);
INSERT INTO COUNTRIES(NAME) VALUES(‘Mauritania’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Mauritius’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Mayotte’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Mexico’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Micronesia’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Moldova’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Monaco’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Mongolia’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Montenegro’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Montserrat’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Morocco’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Mozambique’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Myanmar’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Namibia’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Nauru’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Nepal’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Netherlands’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Netherlands Antilles’);
INSERT INTO COUNTRIES(NAME) VALUES(‘New Caledonia’);
INSERT INTO COUNTRIES(NAME) VALUES(‘New Zealand’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Nicaragua’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Niger’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Nigeria’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Niue’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Norfolk Island’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Northern Mariana Islands’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Norway’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Oman’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Pakistan’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Palau’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Palestine’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Panama’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Papua New Guinea’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Paraguay ‘);
INSERT INTO COUNTRIES(NAME) VALUES(‘Peru’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Philippines’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Pitcairn’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Poland’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Portugal’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Puerto Rico’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Qatar’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Reunion’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Romania’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Russian Federation’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Rwanda’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Saint Helena (UK)’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Saint Kitts and Nevis’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Saint Lucia’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Saint Maarten’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Saint Pierre and Miquelon (FR)’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Saint Thomas’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Saint Vincent and the Grenadines’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Samoa’);
INSERT INTO COUNTRIES(NAME) VALUES(‘San Marino’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Sao Tome and Principe’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Saudi Arabia’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Senegal’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Serbia’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Serbia + Montenegro (old)’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Seychelles’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Sierra Leone’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Singapore’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Slovakia’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Slovenia’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Solomon Islands’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Somalia’);
INSERT INTO COUNTRIES(NAME) VALUES(‘South Africa’);
INSERT INTO COUNTRIES(NAME) VALUES(‘South Georgia and the South Sandwich Islands’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Spain’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Sri Lanka’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Sudan’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Suriname’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Svalbard and Jan Mayen Islands’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Swaziland’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Sweden’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Switzerland’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Syrian Arab Republic’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Taiwan’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Tajikistan’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Tanzania’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Thailand’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Timor-Leste’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Togo’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Tokelau’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Tonga’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Trinidad and Tobago’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Tunisia’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Turkey’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Turkmenistan’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Turks and Caicos Islands’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Tuvalu’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Uganda’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Ukraine’);
INSERT INTO COUNTRIES(NAME) VALUES(‘United Arab Emirates’);
INSERT INTO COUNTRIES(NAME) VALUES(‘United Kingdom’);
INSERT INTO COUNTRIES(NAME) VALUES(‘United States of America’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Uruguay’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Uzbekistan’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Vanuatu’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Vatican City State’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Venezuela’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Vietnam’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Virgin Islands (British)’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Virgin Islands (U.S.)’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Wallis and Futuna Islands’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Western Sahara’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Yemen’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Zaire’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Zambia’);
INSERT INTO COUNTRIES(NAME) VALUES(‘Zimbabwe’);

Read Full Post »

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’);

Read Full Post »