sql:更新分數

create procedure Vendor_add_score
@Vendor_Code nvarchar(50),
@Score float
as
update dbo.Vendor set
Score=@Score+
(select a.Score from dbo.Vendor a
where (a.Vendor_Code=@Vendor_Code))
where (Vendor_Code=@Vendor_Code)
return