use [zhdb]
declare @pid varchar(20),@price money;
set @pid='12010002-00201';
set @price=27.60;
update product set Price=@price,Vip1=@price,Vip2=@price,Vip3=@price where ProductNum=@pid;
select top 1 * from product where productNum =@pid;
go
作者“穿梭在网路上的孩子石宏伟”