Adding Data to Multiple Tables Using Single Query
This is not possible.  The INSERT statement takes a single destination object as per the syntax (BOL reference):

[ WITH &lt;common_table_expression&gt; [ ,...n ] ]
INSERT 
{
        [ TOP ( expression ) [ PERCENT ] ] 
        [ INTO ] 
        { &lt;object&gt; | rowset_function_limited 
          [ WITH ( &lt;Table_Hint_Limited&gt; [ ...n ] ) ]
        }
    {
        [ ( column_list ) ] 
        [ &lt;OUTPUT Clause&gt; ]
        { VALUES ( { DEFAULT | NULL | expression } [ ,...n ] ) [ ,...n     ] 
        | derived_table 
        | execute_statement
        | &lt;dml_table_source&gt;
        | DEFAULT VALUES 
        }
    }
}
[;]


Take note of the &lt;object&gt; placeholder on the 6th line of the syntax snippet.

Is there a particular reason why you want to insert into two tables in one statement?  Perhaps you are looking for both inserts to either succeed or fail as one?  In that case, you would be looking at explicit transactions:

begin tran;
    insert into dbo.YourTable1 ...
    insert into dbo.YourTable2 ...
commit tran;


Besides code brevity and atomicity, I wouldn't see any other reason that you'd want to combine multiple destination tables into a single INSERT statement.