Inserting Data into a Table

The topics in this section describe how to add data to a table in SQL Server 2005.

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.

Community Additions