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.

See Also

Concepts

Updating Data in a Table

Other Resources

Deleting Data in a Table
INSERT (Transact-SQL)
SELECT (Transact-SQL)
WRITETEXT (Transact-SQL)
bcp Utility
BULK INSERT (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance