太晚了,只把好做的第二题做了!等高手来帮你了! create table books
(book_id char(6)
constraint CK_books_book_id check(book_id like '[a-z][0-9][0-9][0-9][0-9][0-9]'),
type_id char(6),
constraint FK_type_id foreign key(type_id) references type(type_id),
book_name char(20) not null,
zu_name char(8) not null,
price smallmoney,
qty int,
pub_name varchar(30) not null,
book_time datetime,
constraint PK_BOOKS_BOOK_ID primary key(book_id)
)
(book_id char(6)
constraint CK_books_book_id check(book_id like '[a-z][0-9][0-9][0-9][0-9][0-9]'),
type_id char(6),
constraint FK_type_id foreign key(type_id) references type(type_id),
book_name char(20) not null,
zu_name char(8) not null,
price smallmoney,
qty int,
pub_name varchar(30) not null,
book_time datetime,
constraint PK_BOOKS_BOOK_ID primary key(book_id)
)
eg:
create table A
(
name varchar(10),
T int
)insert A select 'A',345
insert A select 'A',567create proc T_pc(@name varchar(50))
as
if exists( select 1 from A where name=@name)
select * from A where name=@name
else
print '没有此人的信息'exec T_pc 'A'exec T_pc 'B'