sql 如何在建立一个存储过程时更新两张表的数据

正确的这样做

create proc proc2
(
@OrderID int,
@BookID varchar(20),--更新 orderInfo quantity；更新 orderSheet payment
@BookStock int
)
as
begin

update orderInfo
SET quantity =(quantity + @BookStock)
WHERE orderid = @OrderID
AND bookid = @BookID

update orderSheet
set payment = orderSheet.payment+orderInfo.price*orderInfo.quantity
FROM orderInfo
where orderInfo.orderid = @OrderID
AND orderInfo.bookid = @BookID
AND orderSheet.oid = orderInfo.orderid

end
go