Transact SQL Other Articles Software Reviews
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.