sql查询分析器使用变量

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

转载于:https://blog.51cto.com/390882/668413