TSQL: UPDATE

UPDATE 
        { 
         table_name WITH ( <table_hint_limited> [...n])
         | view_name
         | rowset_function_limited 
        }
        SET 
        {column_name = {expression | DEFAULT | NULL}
        | @variable = expression 
        | @variable = column = expression } [,...n]

    {{[FROM {<table_source>} [,...n] ]

        [WHERE 
            <search_condition>] }
        | 
        [WHERE CURRENT OF 
        { { [GLOBAL] cursor_name } | cursor_variable_name} 
        ] }
        [OPTION (<query_hint> [,...n] )]

UPDATE authors
        SET authors.au_fname = 'Annie'
        WHERE au_fname = 'Anne' 

UPDATE titles
        SET ytd_sales = t.ytd_sales + s.qty
        FROM titles t, sales s
        WHERE t.title_id = s.title_id
        AND s.ord_date = (SELECT MAX(sales.ord_date) FROM sales) 

TSQL: INSERT

INSERT [INTO] 
    { 
     table_name WITH ( <table_hint_limited> [...n])
     | view_name
     | rowset_function_limited 
    }

    {    [(column_list)] 
        { VALUES ( {    DEFAULT 
                        |    NULL
                        |    expression 
                        }[,...n]
            )
        | derived_table
        | execute_statement    
        }
    }
    | DEFAULT VALUES

<table_hint_limited> ::=
    {    INDEX(index_val [,...n])
        | FASTFIRSTROW
        | HOLDLOCK
        | PAGLOCK
        | READCOMMITTED
        | REPEATABLEREAD
        | ROWLOCK
        | SERIALIZABLE
        | TABLOCK 
        | TABLOCKX
    }

INSERT INTO TENANTS..ADDRESS (ADDRESS) VALUES ('129 GABBA ROAD, WOOLLOONGABBA')