Working with Data

After you've created tables, you'll want to put data into the tables and work with the data. You can change data, remove data, or add more data. You can also import and export data to and from other applications.

In SQL Server, you work with data by using data modification statements. You add data with the INSERT statement, change data with the UPDATE, WRITETEXT, or UPDATETEXT statements, and remove data with the DELETE or TRUNCATE TABLE statements.

Each SQL Server statement is by default a transaction. You can process transactions individually or collectively. For example, to add five rows to a table, you can issue five INSERT statements separately, or you can group them into a single transaction.