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 = 'Dependen