After you create a database, tables, and indexes, you can put data into the tables and work with it—adding, changing, and deleting data as necessary.
The commands you use to add, change, or delete data are called data modification statements. These commands include:
insert – adds new rows to a table.
update – changes existing rows in a table.
writetext – adds or changes text, unitext, and image data without writing lengthy changes in the system’s transaction log.
delete – removes specific rows from a table.
truncate table – removes all rows from a table.
See the Reference Manual: Commands.
You can also add data to a table by transferring it from a file using the bulk-copy utility program, bcp. See the Utility Guide.
You can use insert, update, or delete to modify data in one table per statement. Transact-SQL enhancements to these commands let you base modifications on data in other tables, and even other databases.
The data modification commands also work on views, with some restrictions. See Chapter 12, “Views: Limiting Access to Data.”Database owners and the owners of database objects can use the grant and revoke commands to specify the users who are allows to execute data modification commands.Permissions or privileges can be granted to individual users, groups, or the public for any combination of the data modification commands. Permissions are discussed in Chapter 17, “Managing User Permissions,” in the System Administration Guide: Volume 1.
