Microsoft® SQL Server™ 2005: Database Essentials Step by Step

Chapter 10. Inserting Data in Microsoft SQL Server 2005

After completing this chapter, you will be able to:

• Add information to your database

• Secure information using view inserts instead of table inserts

• Import data

• Insert information asynchronously

You have already learned how to retrieve information from the database and handle other special considerations, such as transactions. In this chapter, you will learn how to add information that the user needs into the database from custom applications and other sources.

Using the INSERT Statement

The basis of adding information is the INSERT clause. This clause uses the following syntax:

INSERT INTO [<ServerName>.][<DataBaseName>.]<SchemaName>.<TableName> (<FieldName1>[,<FieldName2>...]) VALUES (<Value1>[,<Value2>..]) ...