O'Reilly logo

Microsoft® SQL Server™ 2005: Database Essentials Step by Step by Solid Quality Learning

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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>..]) ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required