Solo usuarios registrados pueden comentar y agradecer, Logueate o Registrate

Autor Topic: soporte procedure blood castle  (Visto 762 veces)

0 Miembros and 1 Guest are viewing this topic.

Offline faber Posteado: March 27, 2018, 03:41:22 AM

  • 0 puntos por ventas
  • *
  • Rank: Principiante
  • Posts: 10
  • Gracias recibida: 5
  • br
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



Solo usuarios registrados pueden comentar y agradecer, Logueate o Registrate


 

Related Topics

  Subject / Started by Replies Last post
4 Replies
11004 Views
Last post February 04, 2021, 10:42:37 PM
by darkzero2835
0 Replies
1666 Views
Last post June 18, 2017, 05:41:11 PM
by basthialbo
3 Replies
6164 Views
Last post September 07, 2017, 07:27:09 PM
by TioFedEx
3 Replies
7118 Views
Last post February 02, 2019, 06:16:46 PM
by koito89
1 Replies
1498 Views
Last post December 26, 2017, 08:56:09 PM
by Peluuca