Home

	Expand Search

Transact-SQL User's Guide

Chapter 8 Adding, Changing, and Deleting Data

Chapter 8

Adding, Changing, and Deleting Data

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.

Introduction

Permissions

Referential integrity

Transactions

Using the sample databases

Datatype entry rules

char, nchar, unichar, univarchar, varchar, nvarchar, and text

datetime and smalldatetime

binary, varbinary, and image

money and smallmoney

float, real, and double precision

decimal and numeric

int, smallint, and tinyint

timestamp

Adding new data

insert syntax

Adding new rows with values

Inserting data into specific columns

Adding new rows with select

Changing existing data

update syntax

Using the set clause with update

Using the where clause with update

Using the from clause with update

Updates with joins

Updating IDENTITY columns

Changing text and image data

Deleting data

Using the from clause with delete

Deleting from IDENTITY columns

Deleting all rows from a table

truncate table syntax