Uncategorized | Emad's Blog

Archive for the ‘Uncategorized’ Category

Useful SQL Script – Filling Countries table

Posted in Uncategorized, tagged Scripts, SQL on October 1, 2007| 8 Comments »

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 »

Useful SQL Script – Filling languages table

Posted in Uncategorized, tagged Scripts, SQL on October 1, 2007| 1 Comment »

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 »

ASP.NET datagrid conditional formatting

Posted in Uncategorized on September 15, 2007| Leave a Comment »

The idea to conditionally formatting cells in an ASP.NET data grid lies simply with the ItemDataBound Event of the datagrid.

Example:

protected void gridData_ItemDataBound(object sender, DataGridItemEventArgs e)
{
    if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
    {
        Customer cust = (Customer)e.Item.DataItem;

        Int32 daysRemaining =cust.SubscriptionDaysRemaining;
        if (daysRemaining <= 0)
        {
            e.Item.Cells[12].ForeColor = Color.Red;
            e.Item.Cells[12].Font.Bold = true;
            e.Item.Cells[12].Font.Italic = true;
            e.Item.Cells[12].Font.Size = new FontUnit(16);
        }

}

Read Full Post »

Installing web setup project from Visual studio 2005 under Vista

Posted in Uncategorized on August 12, 2007| Leave a Comment »

Under windows vista, when trying to install a web project from visual studio, you may get an error with nearly no useful information at all.

There is a few steps that needs to be taken to get over this, they are well illustrated in:
http://lvildosola.blogspot.com/2007/07/making-web-setup-projects-run-on.html

A full list of visual studio 2005/Vista issues can be found at
http://msdn2.microsoft.com/en-us/vstudio/aa964140.aspx

Read Full Post »

Very Simple (and effective) Web TODO List

Posted in Uncategorized on August 1, 2007| Leave a Comment »

http://tadalist.com/ from 37Signals.

It is a very simple TODO list from the company that prides itself with building application with mush less features than their competitors.

Their idea is to just focus on features that really matter.

http://tadalist.com/ is 100% free to use.

Read Full Post »

Nice "How do I?" Videos from microsoft

Posted in Uncategorized on July 16, 2007| Leave a Comment »

A nice collection of short “how do I?” videos from microsoft covering a wide variety of technologies: ASP.NET, SQL EXPRESS, AJAX, VS Team syste, etc.

http://msdn2.microsoft.com/en-us/asp.net/bb498194.aspx

Read Full Post »

Add Identity Column to Table created by SELECT INTO

Posted in Uncategorized on July 13, 2007| Leave a Comment »

An Easy way to add an Identity column to a table created by SELECT .. INTO is:

Assume the table is created using

SELECT NAME INTO NAMES2 FROM NAMES1

simply add this,

SELECT IDENTITY(INT, 1,1) AS [ID], NAME INTO NAMES2 FROM NAMES1

Read Full Post »

log4net and .NET 2.0 Gotcha

Posted in Uncategorized on July 12, 2007| Leave a Comment »

A single line makes all the difference when using log4net with .NET 2.0

log4net.Config.DOMConfigurator.Configure();

If this line is not included, log4net will not work at all.

Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.

Posted in Uncategorized on July 8, 2007| Leave a Comment »

This Exeption may rise when trying to Fill a table using a Table adapter.

One of the reasons this may happen is if the SQL statement is not Selecting a column that is not null in the DB

for example :

if table has field1, field2, field3 and all do not allow null, This exception will be thrown if you try SELECT field1, field2 from Table.

Of course, there may be other reasons for the excption like actually violating a constraint 🙂

Read Full Post »

Note about Crystal Report (report.Refresh();) method

Posted in Uncategorized on June 12, 2007| Leave a Comment »

I noticed that if the Refresh() method is called on a crystal report after setting the Paramaters programatically, the Refresh method will blank the parameters causing the popup asking about parameters values.

example:

report.SetParameterValue(“note”, note);
report.Refresh();

if this case, the crystal report will still pop up asking about a value for the paramter “note”

Read Full Post »

« Newer Posts - Older Posts »

Emad's Blog

Thoughts/Tips/Shortcuts/Ideas about building software

Archive for the ‘Uncategorized’ Category

Useful SQL Script – Filling Countries table

Useful SQL Script – Filling languages table

ASP.NET datagrid conditional formatting

Installing web setup project from Visual studio 2005 under Vista

Very Simple (and effective) Web TODO List

Nice "How do I?" Videos from microsoft

Add Identity Column to Table created by SELECT INTO

log4net and .NET 2.0 Gotcha

Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.

Note about Crystal Report (report.Refresh();) method

Pages

Email Subscription

Archives