Citar

Hola quiero modificar mi procedimiento para generar "score" en la columna de ScoreDay para que pueda crear ranking de blood castle diaria, semanal y mensual

Citar

Hello I want to modify my procedure to generate "score" in the column scoreday so that I can create daily, weekly and monthly blood castle ranking

Citar

Olá quero modificar minha procedure para gerar "score" na coluna scoreday para que eu possa criar ranking blood castle diario,semanal e mensal

Citar

USE [MuOnline]
GO
/****** Object:  StoredProcedure [dbo].[WZ_RankingBloodCastle]    Script Date: 27/03/2018 04:15:29 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER Procedure [dbo].[WZ_RankingBloodCastle]
@Account varchar(10),
@Name varchar(10),
@Score int
AS
BEGIN

SET NOCOUNT ON
SET XACT_ABORT ON

IF NOT EXISTS (SELECT Name FROM RankingBloodCastle WHERE Name=@Name)
BEGIN

   INSERT INTO RankingBloodCastle (Name,Score) VALUES (@Name,@Score)

END
ELSE
BEGIN

   UPDATE RankingBloodCastle SET Score=Score+@Score WHERE Name=@Name

END

SET NOCOUNT OFF
SET XACT_ABORT OFF

END