qq_45863239的博客

create procedure s1@Rname nvarchar(50)='王小明',@Btitle nvarchar(50)output,@BorrowDate date output,@Bauthor nvarchar(50) outputas select @Rname=Rname,@Btitle=Btitle,@BorrowDate=BorrowDate,@Bauthor=Bauthorfrom Book,Borrow,Reader where @Rname=Rname and ..

begin transaction graduateuse library1godelete from Reader where Rno='R05'delete from Borrow where Rno='R05'gocommit transaction graduategobegin transaction borrow1use library1godeclare @Bno nchar(10),@num float,@Borrnum int,@Rno nchar(10),@B.