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

Topic	Description
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.