Citação Originally Posted by lorranmota Ver Post
use [muonline]
go
/****** object: Storedprocedure [dbo].[wz_custommonsterreward] script date: 14/05/2016 02:12:42 ******/
set ansi_nulls on
go
set quoted_identifier on
go


create procedure [dbo].[wz_custommonsterreward]
@account varchar(10),
@name varchar(10),
@monsterclass int,
@mapnumber int,
@rewardvalue1 int,
@rewardvalue2 int
as
begin


set nocount on
set xact_abort on


update pcpointdata set pcpoint=pcpoint+@rewardvalue1 where accountid=@account


set nocount off
set xact_abort off


end

esta query esta incompleta!! Favor tem como postar ela completa, para podermos modificar a mesma...