|
5>
6>
7>
8> CREATE TABLE authors(
9> au_id varchar(11),
10> au_lname varchar(40) NOT NULL,
11> au_fname varchar(20) NOT NULL,
12> phone char(12) NOT NULL DEFAULT ('UNKNOWN'),
13> address varchar(40) NULL,
14> city varchar(20) NULL,
15> state char(2) NULL,
16> zip char(5) NULL,
17> contract bit NOT NULL
18> )
19> GO
1> insert authors values('7', 'White', 'Sylvia', '777 777-7777', '1 Pl.', 'Rockville', 'MD', '77777', 1)
2> insert authors values('8', 'Yellow','Heather','888 888-8888', '3 Pu', 'Vacaville', 'CA', '88888', 0)
3> insert authors values('9', 'Gold', 'Dep', '999 999-9999', '5 Av.', 'Oakland', 'CA', '99999', 0)
4> insert authors values('10', 'Siler', 'Dean', '000 000-0000', '4 Av.', 'Oakland', 'CA', '00000', 1)
5> GO
(1 rows affected)
(1 rows affected)
(1 rows affected)
(1 rows affected)
1>
2> CREATE TABLE publishers(
3> pub_id char(4) NOT NULL,
4> pub_name varchar(40) NULL,
5> city varchar(20) NULL,
6> state char(2) NULL,
7> country varchar(30) NULL DEFAULT('USA')
8> )
9> GO
1>
2>
3> insert publishers values('1', 'Publisher A', 'Vancouver', 'MA', 'USA')
4> insert publishers values('2', 'Publisher B', 'Washington', 'DC', 'USA')
5> insert publishers values('3', 'Publisher C', 'Berkeley', 'CA', 'USA')
6> GO
(1 rows affected)
(1 rows affected)
(1 rows affected)
1>
2>
3> BEGIN TRAN
4> insert authors values('1', 'Joe', 'Abra', '111 111-1111', '6 St.', 'Berkeley', 'CA', '11111', 1)
5> insert authors values('2', 'Jack', 'Majo', '222 222-2222', '3 St.', 'Oakland' , 'CA', '22222', 1)
6> insert authors values('3', 'Pink', 'Cherry', '333 333-3333', '5 Ln.', 'Vancouver', 'BC', '33333', 1)
7> insert authors values('4', 'Blue', 'Albert', '444 444-4444', '7 Av.', 'Vancouver', 'BC', '44444', 1)
8> insert authors values('5', 'Red', 'Anne', '555 555-5555', '6 Av.', 'Regina', 'SK', '55555', 1)
9> insert authors values('6', 'Black', 'Michel', '666 666-6666', '3 Pl.', 'Regina', 'SK', '66666', 1)
10>
11> SELECT * FROM authors
12> COMMIT TRAN
13> BEGIN TRAN
14> insert publishers values('4', 'Publisher D', 'New York', 'NY', 'USA')
15> insert publishers values('5', 'Publisher E', 'Chicago', 'IL', 'USA')
16> insert publishers values('6', 'Publisher F', 'Dallas', 'TX', 'USA')
17> insert publishers values('7', 'Publisher G', 'Vancouver', 'BC', 'Canada')
18> insert publishers values('8', 'Publisher H', 'Paris', NULL, 'France')
19> COMMIT TRAN
20> GO
(1 rows affected)
(1 rows affected)
(1 rows affected)
(1 rows affected)
(1 rows affected)
(1 rows affected)
au_id au_lname au_fname phone address city state zip contract
----------- ---------------------------------------- -------------------- ------------ ---------------------------------------- -------------------- ----- ----- --------
7 White Sylvia 777 777-7777 1 Pl. Rockville MD 77777 1
8 Yellow Heather 888 888-8888 3 Pu Vacaville CA 88888 0
9 Gold Dep 999 999-9999 5 Av. Oakland CA 99999 0
10 Siler Dean 000 000-0000 4 Av. Oakland CA 00000 1
1 Joe Abra 111 111-1111 6 St. Berkeley CA 11111 1
2 Jack Majo 222 222-2222 3 St. Oakland CA 22222 1
3 Pink Cherry 333 333-3333 5 Ln. Vancouver BC 33333 1
4 Blue Albert 444 444-4444 7 Av. Vancouver BC 44444 1
5 Red Anne 555 555-5555 6 Av. Regina SK 55555 1
6 Black Michel 666 666-6666 3 Pl. Regina SK 66666 1
(1 rows affected)
(1 rows affected)
(1 rows affected)
(1 rows affected)
(1 rows affected)
1>
2> drop table authors;
3> drop table publishers;
4> GO
1>
2>
|