Monday, 29 May 2006

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')

No comments: