创建存储过程prcgetprice，通过输入图书编号，使用输出参数返回图书价格，根据题目完成以下代码的填空。create proc prcgetprice@BookID varchar(50),@Price float OUTPUT asbegin try if exists(select * from BookInfo where BookID=@BookID) begin declare @Price float SET @Price=0 select @Price =Price from BookInfo where BookID=@BookIDend trybegin catch print 'error'end catch执行prcgetprice存储过程查询图书编号为B001图书的价格，填充语句。declare @Price floatexec prcgetprice 'B001'，@Price ___print @Price
创建存储过程prcgetprice，通过输入图书编号，使用输出参数返回图书价格，根据题目完成以下代码的填空。create proc prcgetprice@BookID varchar(50),@Price float OUTPUT asbegin try if exists(select * from BookInfo where BookID=@BookID) begin declare @Price float SET @Price=0 select @Price =Price from BookInfo where BookID=@BookIDend trybegin catch print 'error'end catch执行prcgetprice存储过程查询图书编号为B001图书的价格，填充语句。declare @Price floatexec prcgetprice 'B001'，@Price ___print @Price
1