Feeds:
Posts
Comments

Posts Tagged ‘SQL’

Service Pack 1 for SQL 2008 R2 is Released

Posted in News, tagged on July 17, 2011| Leave a Comment »

http://www.microsoft.com/download/en/details.aspx?id=26727

Read Full Post »

SQL 2008 R2 released

Posted in News, tagged on April 21, 2010| Leave a Comment »

http://www.infoworld.com/d/applications/microsoft-unleashes-long-awaited-sql-2008-update-430?source=rss_infoworld_news

Read Full Post »

SSW Standard Rules

Posted in Uncategorized, tagged , , , , , on October 5, 2007| Leave a Comment »

SSW is a Sydney based Consulting firms. They published (and frequently update) a very popular set of best practices covering various areas in software development along with other miscellaneous topics(as far as booking airline tickets).

Here find the list (copied from http://us.ssw.com.au/ssw/Standards/default.aspx )

The links point to SSW web site.

    Management
  1. Rules to Successful Projects* Popular *
  2. Rules to Successful Project Management
  3. Rules to Managing Software Consultants
  4. Rules to Better Team Members
  5. Rules to Managing Your Dead Time
  6. Rules to Better Project Manager Methodology
  7. Using SSW eXtreme Emails! to Manage Projects
  8. Rules to Better Accounting
    .NET/SQL/TFS Code & Application Design
  9. Rules to Better Code
  10. Rules to Better SQL Server Databases
  11. Rules to Better .NET Projects
  12. Rules to Better Large .NET projects
  13. Rules to Better Windows Forms
  14. Rules to Better Windows Forms – Click Once
  15. Rules to Better Unit Tests
  16. Rules to Better Source Control
  17. Rules to Better Setups
  18. Rules to Better Interfaces
  19. Rules to Better Developer Methodology
  20. Rules to Better VB6 Migration to .NET
  21. Rules to Better DotNetNuke Development
  22. Rules to Better Project Management with TFS
    Access Code & Application Design
  23. Rules to Better Access Applications (front-ends inc. queries)
  24. Rules to Better Access UI
  25. Rules to Better Access Databases (back-ends)
  26. Rules to Upsizing your Access Database to SQL Server
    Web Sites
  27. Rules to Better Websites – Navigation
  28. Rules to Better Websites – Layout & Formatting
  29. Rules to Better Websites – Development
  30. Rules to Better Websites – Branding and Marketing
  31. Rules to Better Websites – Online Transactions
  32. Rules to Better Websites – Graphics
  33. Rules to Better Websites – Tuning and Maintenance
    Operating Systems
  34. Rules to Better Windows Vista Deployment
    Communication
  35. Rules to Better Email * Popular *
  36. Rules to Better Instant Messenger
    Reporting Solutions
  37. Rules to Better Business Intelligence
  38. Rules to Better MS SQL Reporting Services
    Marketing
  39. Rules to Better Google Rankings * Popular *
  40. Rules to Better Outbound Calls
  41. Rules to Better Inbound Calls
  42. Rules to Better Marketing
  43. Rules to Better Branding
    Networking
  44. Rules to Better Windows 2003
  45. Rules to Better ISA Server
  46. Rules to Better Networks
  47. Rules to Better Virtual PCs
    Microsoft CRM
  48. Rules to Better Microsoft CRM
    The Best Third Party Tools
  49. Introduction
  50. The Best Tools for .NET (General)
  51. The Best Tools for Web Development
  52. The Best Tools for Web Development (ASP.NET Controls)
  53. The Best Tools for Windows Forms
  54. The Best Tools for Windows Forms Development
  55. The Best Tools for SQL Server
  56. The Best Tools for Access
  57. The Best Tools for Outlook
  58. The Best Tools for Internet Explorer
  59. The Best Tools for Windows
  60. The Best Tools for Network
  61. The Best Tools for Exchange Server
  62. The Best Tools for Pocket PC
  63. The Best Image Libraries
    Naming Conventions
  64. SQL Server Object Naming Conventions
  65. SQL Server Index Naming Conventions
  66. SQL Server Relationship Naming Conventions
  67. SQL Server Stored Procedure Naming Conventions
  68. SQL Server Stored Procedure Formatting Standards
  69. .NET Object Naming Conventions
  70. .NET Project Naming
    Documentation
  71. Rules to Better Technical Documentation
    Other
  72. Rules to booking better flights

Read Full Post »

Useful SQL Script – Filling Countries table

Posted in Uncategorized, tagged , 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 , 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 »