Transact-SQL Reference

This is the MS location for the Transact-SQL Reference

Unions

This is the first UNION SQL code I have written:

SELECT Field1, Field2, Field3 FROM Table1
UNION SELECT Field1, Field2, Field3 FROM MasterTOStatus;

And it work!

SQL Documentation

Microsoft Transcat-SQL Reference online document.

SQL 2005 Server

• Elements of Transact-SQL
• Query Fundamentals
• Using SQL Server Tutorials
• Query Fundamentals

SQL Access 2000

• Fundamental Microsoft Jet SQL
• Intermediate Microsoft Jet SQL
• Advanced Microsoft Jet SQL

IBM Informix

• Syntax
• Reference
• Tutorial

SQL Comments

The standard SQL comment is '--'. This works in SQL Server. However, Access doesn't permit comments.

Access SQL

How one looks at the Access SQL is a bit different because the form using to different terminologies in visually building a query.

Append: This means use a 'INSERT INTO'

I need to learn more about how the graphical build tools work in Access.

In specifying the query using the graphical interface you must specify at least one 'destination field.

From the Access Query From one can select either

• Select Query
• Update Query
• Append Query

In addtion on can select the following additional queries.

• Crosstab Query
• Make-table Query
• Delete Query

In creating a query on can use the ‘Design View’ or one of the following query wizards:

• Simple Query Wizard
• Crosstab Query Wizard
• Find Duplicates Query Wizard
• Find Unmatched Query Wizard

DELETE FROM

The DELETE statement is used to delete given row or rows or all rows in a table or view.

DELETE [*] FROM table_name [WHERE column_name = some_value];

UPDATE

The UPDATE statement is used to modify the data in a given row or all rows of a table. If are no row in the table nothing will be done.

Syntax:

UPDATE table_name SET column_value [WHERE column_name = some_value];

column_value :: column_name = new_value[, column_name = new_value ]