Access and change relational data
adding data
Microsoft® SQL ServerTM supports adding data to the table using the following methods:
INSERT statement with one of the following two options:
The VALUES clause is inserted into a row. SELECT subquery, used to insert data in a self-table or view. Database Application Interface (API) Processing Results Inserted Support Options. The WriteText statement and several database API options can be used to add NTEXT, TEXT, or Image data to one line. Functions in Database API (ADO, OLE DB, ODBC, and DB-Library) add new NTEXT, TEXT, and Image data to a row. SELECT INTO statement can be used to create a new table containing all rows containing the Select INTO result set. The large-capacity replication component used to insert a number of rows Specifies three ways: large-capacity replication operations:
Large Capacity Copy Procedure (BCP Utility), a command line prompt utility. Use the Bulk INSERT statement in Transact-SQL batch, stored procedures, and triggers. The large-capacity replication API for OLE DB, ODBC, and DB-Library applications.
The INSERT statement works in the view and is subject to some restrictions. For more information, see Creating a view.
© 1988-2000 Microsoft Corporation. all rights reserved.
