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.

See Also

Reference

INSERT (Transact-SQL)

SELECT (Transact-SQL)

WRITETEXT (Transact-SQL)

bcp Utility

BULK INSERT (Transact-SQL)

Concepts

Updating Data in a Table

Other Resources

Deleting Data in a Table