《作业3打字内容.docx》由会员分享,可在线阅读,更多相关《作业3打字内容.docx(1页珍藏版)》请在三一文库上搜索。
CREATE TABLE stores (stor_id int NOT NULL,stor_name varchar (40),stor_address varchar (40),city varchar (20),state varchar (5),zip varchar (5)CREATE TABLE jobs (job_id smallint IDENTITY (1, 1) NOT NULL,job_desc varchar (50) NOT NULL,min_lvl tinyint NOT NULL,max_lvl tinyint NOT NULL)CREATE TABLE pub_info (pub_id int NOT NULL,pr_info varchar (100)insert into pub_info(pub_id,pr_info) values(1,good)select * from pub_info