我在做图书管理系统时在SQL的查询分析器中建了一存储过程:
create procedure A @HBno varchar(10)
as declare
@HBname varchar(30)
begin
select Bname
into HBname
from Book
where Bno=@HBno;
if @HBname='操作系统'
select Bwriter,Bprice,BR.Rno,Rname
from Book,BR,Reader
where BR.Bno=HBno and BR.Bno=Book.BNo and BR.Rno=Reader.Rno;
end但执行这一存储过程时总出错
应该怎样正确的执行呢?
create procedure A @HBno varchar(10)
as declare
@HBname varchar(30)
begin
select Bname
into HBname
from Book
where Bno=@HBno;
if @HBname='操作系统'
select Bwriter,Bprice,BR.Rno,Rname
from Book,BR,Reader
where BR.Bno=HBno and BR.Bno=Book.BNo and BR.Rno=Reader.Rno;
end但执行这一存储过程时总出错
应该怎样正确的执行呢?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货