Showing posts from January 16, 2011

MSSQL Statements Syntax

Select Statement
Update Statement
Insert Statement
Delete Statement
Select Into Statement

Many times I forget the exact syntax I should use whether I'm writing in MSSQL, My-SQL or Oracle.  This post is the first out of three posts designed to gather basic database statements and show a simple and clean example to them.

Select Statement: Syntax 1: SELECT column_1, column_3
                     FROM Table
Example: SELECT ID, Name
                FROM tbl_customers
Syntax 2: SELECT * FROM Table (meaning - select all columns).

Example: SELECT * FROM tbl_customers

Update Statement: Syntax 1: UPDATE Table
                    column_1 = 'value'
Example: UPDATE tbl_customers
                    Name = 'Elad'
This is a very bad example for UPDATE statement since this one will update -ALL- the names to 'Elad'.
Syntax 2: UPDATE Table
                    column_1 = 'value'                    WHERE column_2 = 'Dependency_Term'
Example: UPDATE tbl_customers