Change the phone number of authors living in Gary, IN, back to the DEFAULT value : Update « Insert Delete Update « SQL Server / T-SQL Tutorial

4> CREATE TABLE authors(
5>    au_id          varchar(11),
6>    au_lname       varchar(40)       NOT NULL,
7>    au_fname       varchar(20)       NOT NULL,
8>    phone          char(12)          NOT NULL DEFAULT ('UNKNOWN'),
9>    address        varchar(40)           NULL,
10>    city           varchar(20)           NULL,
11>    state          char(2)               NULL,
12>    zip            char(5)               NULL,
13>    contract       bit               NOT NULL
14> )
15> GO
1> insert authors values('1',  'Joe',   'Abra',   '111 111-1111', '6 St.', 'Berkeley',  'CA', '11111', 1)
2> insert authors values('2',  'Jack',  'Majo',   '222 222-2222', '3 St.', 'Oakland' ,  'CA', '22222', 1)
3> insert authors values('3',  'Pink',  'Cherry', '333 333-3333', '5 Ln.', 'Vancouver', 'BC', '33333', 1)
4> insert authors values('4',  'Blue',  'Albert', '444 444-4444', '7 Av.', 'Vancouver', 'BC', '44444', 1)
5> insert authors values('5',  'Red',   'Anne',   '555 555-5555', '6 Av.', 'Regina',    'SK', '55555', 1)
6> insert authors values('6',  'Black', 'Michel', '666 666-6666', '3 Pl.', 'Regina',    'SK', '66666', 1)
7> insert authors values('7',  'White', 'Sylvia', '777 777-7777', '1 Pl.', 'Rockville', 'MD', '77777', 1)
8> insert authors values('8',  'Yellow','Heather','888 888-8888', '3 Pu',  'Vacaville', 'CA', '88888', 0)
9> insert authors values('9',  'Gold',  'Dep',    '999 999-9999', '5 Av.', 'Oakland',   'CA', '99999', 0)
10> insert authors values('10', 'Siler', 'Dean',   '000 000-0000', '4 Av.', 'Oakland',   'CA', '00000', 1)
11> GO

(1 rows affected)

(1 rows affected)

(1 rows affected)

(1 rows affected)

(1 rows affected)

(1 rows affected)

(1 rows affected)

(1 rows affected)

(1 rows affected)

(1 rows affected)
1>
2>
3> 
4> 
5> UPDATE authors
6>     SET phone=DEFAULT
7> WHERE city='Gary' AND state='IN'
8> GO

(0 rows affected)
1>
2> drop table authors;
3> GO
1>

2.5.Update
	2.5.1.	The syntax of the UPDATE statement
	2.5.2.	Syntax of UPDATE with a Join
	2.5.3.	An UPDATE statement that updates all the Billings for a Banker based on the Banker's name
	2.5.4.	An UPDATE statement that changes the terms of all Billings for Bankers in three states
	2.5.5.	Limiting Rows to Be Updated
	2.5.6.	Assigning Update Values Using Subqueries
	2.5.7.	An UPDATE statement that uses an arithmetic expression to assign a value to a column
	2.5.8.	Updating using two subqueries.
	2.5.9.	Updating Data Using the CASE Expression
	2.5.10.	An UPDATE statement that assigns the maximum due date in the table to a specific Billing
	2.5.11.	Violating the constraint in an update statement
	2.5.12.	SET other columns to their default value
	2.5.13.	Change the phone number of authors living in Gary, IN, back to the DEFAULT value
	2.5.14.	An UPDATE statement with top
	2.5.15.	Update table in a transaction
	2.5.16.	Updating Large Value Data Type Columns with WRITE