Inserting Data into a Table
The topics in this section describe how to add data to a table in SQL Server 2005.
In This Section
Adding Rows by Using INSERT and SELECT
Describes how to insert rows using the INSERT and SELECT INTO statements.
Adding a Row by Using a Result Set Position
Describes the database application programming interfaces (APIs) support options for inserting data while processing a result set.
Adding ntext, text, or image Data to Inserted Rows
Describes how to use WRITETEXT and database API options to insert text, ntext, and image data.
Adding Rows by Using Bulk Copy Operations
Describes how to use the bulk copy operations to insert large numbers of rows.