Migrating INSERT Statements from Oracle to SQL Server

The INSERT statements for Oracle and Microsoft® SQL Server™ are similar.

Oracle SQL Server
INSERT INTO
{table_name | view_name | select_statement} [(column_list)]
{values_list | select_statement}
INSERT INTO
{table_name | view_name}
[(column_list)]
{values_list | select_statement | execute_statement}

See Also

INSERT

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.