What is SQL? SQL stands for Structured Query Language and is the lingua franca in the database world. SQL is a standard that is used by all database vendors and programmers to define, extract and access the information that is stored in databases. SQL began life as an IBM creation but was standardized by the American National Standards Institute (ANSI) and the International Organization for Standardization (ISO) as ANSI/ISO SQL in 1988. Since then ANSI/ISO SQL standard continued to evolve. The ANSI-SQL group has since published three standards over the years:
1. SQL89 (SQL1)
2. SQL92 (SQL2)
3. SQL99 (SQL3)
SQL is a query language. It is English-like and easy to use. However, although there are more than 90 SQL reserved words, most programmers seldom use more than the following handful of commands - SELECT, INSERT, UPDATE, DELETE, FROM, WHERE, HAVING, BETWEEN, LIKE, OR, AND, NOT, IN, ORDER, GROUP and BY.
For example, if you had a database table named "employees" and you wanted to retrieve all records where the employee has the last name "goodman", you would use the following SQL statement:
SELECT * FROM employees WHERE lastname = 'goodman';
There are many different categories of SQL statements but the basic ones which all programmers should be familiar with are the SQL statements that:
1. Create tables and manipulate their definitions
2. Query the table data
3. Manipulate the table data
SQL is predominantly used by 2 types of users - programs and humans (keying in the commands through a database client) - to pass instructions to databases. SQL commands can be keyed into a database client like the MySQL Query Browser or the SQL Server Enterprise Manager and executed to either return a result or modify records in the database. SQL can also be used in conjunction with programming language or scripting language like Microsoft Visual Basic or PHP to communicate with the database.
Although SQL is a world standard, it is unfortunate that most database vendors have come up with different dialects and variations. This is because every database vendor wants to differentiate their database products from the crowd. One good example is Microsoft SQL Server's TRANSACT-SQL. TRANSACT-SQL is a superset of SQL and is designed for use only with Microsoft SQL Server. Although it does make programming much easier for software developers, it is not compliant with other databases like Oracle or MySQL - making TRANSACT-SQL programs non database-portable. As such, although many of these features are powerful and robust, it is good practice to exercise caution and limit your SQL use to be compliant with the ANSI/ISO SQL standards and ODBC-Compliant.
Courtesty of sqlprimer.com. For more information, please contact the Webmaster of SQLPrimer.com - sqlprimer.com
Wood Dale Chicago prom limo .. Lockport Chicago limo O’HareMost interactive websites nowadays require data to be presented dynamically... Read More
You hear a great deal about the Internet these days... Read More
Everyone wants one.Everyone wishes they knew how to make one.SOME... Read More
Through the explosive growth of the Web, companies have realized... Read More
When a user signs up at your website, you may... Read More
Like most average persons, I wanted some extra money to... Read More
Optimize your time. How much time each day must you... Read More
You've decided to create a website to market your products... Read More
Before you start building your site, ask yourself "WHY?". Why... Read More
Keywords in Search Engine Optimizing and Search Engine Marketing are... Read More
"I am a writer, not a business-person. I don't want... Read More
SiteSpinnerSiteSpinner is a user-friendly web site development tool that includes... Read More
Failure, just like success, is measured differently by each and... Read More
1. As the first step, "Hire a web designer."First create... Read More
Absolutely everything stems from the purpose of your website -... Read More
The Disability Discrimination Act states that service providers must not... Read More
Most people know they need a website in order to... Read More
Yahoo has long offered email, an online calendar, notes, bookmarks,... Read More
You have seen those web pages where they have the... Read More
Many small businesses have the misconception that their business can... Read More
When most people build a web site, they think one... Read More
An accessible Web site is easily approached, easily understood, and... Read More
You don't believe in astrology but you check your horoscope... Read More
So you finally decided to invest in a web presence... Read More
The needs of screen magnifier users are overlooked when implementing... Read More
Antigo wedding limo ..Many small businesses have the misconception that their business can... Read More
--------------------------------Why Should You Create a website?--------------------------------A. What do you want... Read More
If you are developing your website on a host that... Read More
We all start out the same. Some have budgets, some... Read More
You work hard to build traffic to your web page.... Read More
When most people build a web site, they think one... Read More
More and more non-profit organizations are developing websites to help... Read More
A simple website stats counter is not enough if you... Read More
There are lots of HTML editors on the market, however,... Read More
Better Web Site ROIHow to increase your business profitability by... Read More
1. The first page appears quickly.It's a good way to... Read More
An additional benefit of website accessibility is an improved performance... Read More
The cost of setting up a web site is dirt... Read More
In the late 1990's three San Francisco based web developers... Read More
There are many different traffic analysis tools, ranging from simple... Read More
Thousands of people are now making a living online and... Read More
I can't think of any business alive today that couldn't... Read More
So you have decided that you want to do freelance... Read More
When you consider the billions of individuals and companies on... Read More
Every online entrepreneur I talk to is asking the same... Read More
The internet has taken over our lives with a vengeance,... Read More
I recently received an unsolicited e-mail from some company offering... Read More
A PHP Redirect automatically transfers a web user from one... Read More
Making maximum profit from your law firm website is important,... Read More
Fresh website content for your visitors can be of real... Read More
Web Development |