After completing this chapter, you will be able to:
Add information to your database
Secure information using view inserts instead of table inserts
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.
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>..]) ...