Brettb.Com
  HOME | ABOUT ME | BIOTECHNOLOGY | ARTICLES | GALLERY | CONTACT
Search: Go
TECHNICAL ARTICLES
 ASP
 ASP.NET
 JavaScript
 Transact SQL
 Other Articles
 Software Reviews

PHOTO GALLERIES
 Canon EOS 300D Samples
 Akihabara Maids!
 More Galleries...

TRAVEL LOG
 2009: China
 2008: Tokyo
 2007: Tokyo
 2006: Hong Kong
 2005: New York City

MORE STUFF
 Search Engine Optimisation
 Build an ASP Search Engine
 My Tropical Fishtank
 Autoglass
 SQL Month Name
 SQL Get Date Today
 SQL Year Month
 Other New Stuff...

POPULAR STUFF
 Regular Expressions
 Index Server & ASP
 JavaScript Ad Rotator

Home > Articles > Transact SQL Programming Articles > How to create SQL

SQL Server Help: How to create SQL

SQL is short for Structured Query Language.  SQL is a programming language used to program databases. A lot of different databases support SQL. Databases that support SQL usually support the same basic SQL language.

You can create SQL in a text editor such as the Windows Notepad text editor or TextPad. Some databases also have their own software tools for creating SQL.

Popular database packages that support SQL include Microsoft Access (part of Microsoft Office), Microsoft SQL Server, Oracle and MySQL.

Microsoft Access is commonly used in small businesses. It allows you to create SQL by writing the SQL by hand in the Query editor window.

Microsoft SQL Server is a very powerful database. It tends to be used by larger businesses. SQL for SQL Server can be created using the SQL Server Management Studio. It's also possible to create SQL using the Query Analyser.

MySQL is an open source database that supports SQL. MySQL is largely command line based, so SQL can be created in a command line. To create SQL for MySQL it is more common to use one of the graphical user interface (GUI) applications available for MySQL.

Databases are normally based around the concept of data being stored in database tables. SQL can then be used to retrieve the data. Database in tables is stored in rows. Each row has a value for a particular column (such as Product Name).

This is a SQL query that will retrieve a list of items from the database table called products:

SELECT * FROM products

The "*" is used to specify that all of the columns in the database. It's also possible to specify which columns should be retrieved from the database:

SELECT ProductID, ProductName, ProductPrice FROM products

It's also possible to create a SQL query for ordering the products:

SELECT * FROM products ORDER BY ProductName

This is a very brief introduction which shows how to create SQL. SQL can also be created to insert data into a database table, or update the data that is already there. SQL also has a lot of other features such as being able to spread data across different tables, or performing mathematical calculations such as rounding numbers or counting items.

SQL can be created for linking databases to websites or Windows desktop applications. Database enabled websites are normally written in a scripting language like PHP or ASP, or a programming language such as ASP.NET or Java.

Useful Links

  • The SQL Documentation Tool automatically builds technical documentation for Microsoft SQL Server databases, saving you time and money. A trial version is available for download.

  Site Map | Privacy Policy

All content is 1995 - 2012