4>
5> CREATE TABLE Authors(
6> au_id varchar(11) NOT NULL,
7> au_lname varchar(40) NOT NULL,
8> au_fname varchar(20) NOT NULL,
9> phone char(12) NOT NULL,
10> address varchar(40) NULL,
11> city varchar(20) NULL,
12> state char(2) NULL,
13> zip char(5) NULL,
14> contract bit NOT NULL
15> );
16> GO
1>
2> CREATE PROC AuthorsInState
3> @state char(2)
4> AS
5> SELECT
6> *
7> FROM
8> authors
9> WHERE
10> state = @state
11> GO
1>
2> drop proc AuthorsInState;
3> GO
1>
2> drop table Authors;
3> GO
1>
2>
3>
4>