1299 Sorunsuz grade ve sembol güncelleme kod tek kodla

 

1299 Database sorunsuz  Grade ve sembol kod ekleme tek kodla kolaylıkla güncelleme olacak ama gerekli prosedürleri sırasıyla giriniz.

Not: Sql hata verirse ALTER yazan yeri CREATE yap.

1. Prosedür  Kod

USE [Kn_Online]
GO
/****** Object:  StoredProcedure [dbo].[UPDATE_USER_KNIGHTS_RANK]    Script Date: 7/31/2022 9:05:59 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[UPDATE_USER_KNIGHTS_RANK]
AS

DECLARE @strUserId char(21)
DECLARE @Loyalty int
DECLARE @Knights int
DECLARE @KnightName char(50)
DECLARE @IsValidKnight int
DECLARE @Index smallint 
DECLARE @IsValidCount int
DECLARE @RankName varchar(30)

SELECT @IsValidCount = Count(*) FROM USER_KNIGHTS_RANK

IF @IsValidCount < 100
BEGIN

[only the first 25 lines shown in this example]

2 Prosedür kod 

USE [Kn_Online]
GO
/****** Object:  StoredProcedure [dbo].[UPDATE_USER_PERSONAL_RANK]    Script Date: 7/31/2022 9:10:12 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


ALTER PROCEDURE [dbo].[UPDATE_USER_PERSONAL_RANK]

AS

IF EXISTS (SELECT * FROM SYSOBJECTS WHERE id = object_id(N'[dbo].[KPERSONAL_RANK]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[KPERSONAL_RANK]

IF EXISTS (SELECT * FROM SYSOBJECTS WHERE id = object_id(N'[dbo].[EPERSONAL_RANK]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[EPERSONAL_RANK]

CREATE TABLE [KPERSONAL_RANK]
(
    [nRank] [int] IDENTITY (1, 1) NOT NULL,
    [strUserID] char(21) NOT NULL,
    [LoyaltyMonthly] int NOT NULL,
    [Loyalty] int NOT NULL,
[only the first 25 lines shown in this example]

3 Prosedür kod

USE [Kn_Online]
GO
/****** Object:  StoredProcedure [dbo].[RANK_KNIGHTS]    Script Date: 7/31/2022 9:12:40 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO

ALTER PROCEDURE [dbo].[RANK_KNIGHTS]
AS

UPDATE KNIGHTS SET Points=0

SET NOCOUNT ON
DECLARE @KnightsIndex smallint
DECLARE @SumLoyalty int
DECLARE job1 CURSOR FOR

SELECT IDNum FROM KNIGHTS

OPEN job1
FETCH NEXT FROM job1
INTO @KnightsIndex
WHILE @@fetch_status = 0 
BEGIN
[only the first 25 lines shown in this example]

USE [Kn_Online]
GO
/****** Object:  StoredProcedure [dbo].[UPDATE_ALL]    Script Date: 7/31/2022 9:04:29 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER Procedure [dbo].[UPDATE_ALL] 
AS


EXEC UPDATE_USER_KNIGHTS_RANK
EXEC UPDATE_USER_PERSONAL_RANK
EXEC RANK_KNIGHTS

Return

TÜM GEREKLİ KODLARİ GİRİLDİ ARTİK TEK KODLA KOLAYCANA SORUNSUZ ŞEKİLDE GUNCELLEME YAPABİLECEKSİNİZ.

TEK KODUMUZ AŞAĞIDAKİ

exec update_all