[PayLaşım]oLay oLay oLay Servere Res Atmadan Grade SymboL Res HayK0 FarkıyLa^^

Aşağıdaki işlemleri yaparken Windows Authentication olarak Giriş Yapın .

1. Adım :

Aşağıdaki Kodu Query Anlyzer'a Girin.

Kod:
create table [nphuman]
(
[nRank] [int] IDENTITY (1, 1) NOT NULL ,
[strUserID] char(21) NOT NULL,
[Loyalty] int NOT NULL,
[LoyaltyMonthly] int NOT NULL,
)

create table [npkarus]
(
[nRank] [int] IDENTITY (1, 1) NOT NULL ,
[strUserID] char(21) NOT NULL,
[Loyalty] int NOT NULL,
[LoyaltyMonthly] int NOT NULL,
)

Kodu Girdikten sonra

user_personal_rank tablosunu açıyoruz. 1'den 30'a kadar sırayla bilgileri giriyoruz
Kod:
nRank = 1 - 30 ( 1'den 30'a kadar sayıları sıralı olarak ekliyeceksiniz. )( Örn : 1234567.. diye eklenecek.. )strPosition = Gold ( Hepsi Standart Gold Olarak Kalacak . )nElmoUP = 0strElmoUserID = 1111nElmoLoyaltyMonthly = 1111nElmoCheck = 1000000nKarusUP = 0strKarusUserID = 1111nKarusLoyaltyMonthly = 1111nKarusCheck = 1000000nSalary = 1000000UpdateDate = 30.04.2008 21:30:00 user_personal_rank bu şekilde bir görüntüye sahip olacaktır kodları eklediğinizde.

[Resimleri görebilmek için üye olun veya giriş yapın.]

This image has been resized. Click this bar to view the full image. The original image is sized 1024x383 and weights 82KB.

Bunlarıda Ekledikten sonra procedure'yi ekleyelim.
Kod:
CREATE PROCEDURE otonpsimgesi AS/* webmsn */declare @KNP int,@HNP intselect @KNP = nKarusLoyalty from user_knights_rank where shindex = 6select @HNP = nElmoLoyalty from user_knights_rank where shindex = 6truncate table npkarusinsert npkarus select top 30 strUserID, Loyalty, LoyaltyMonthly from USERDATA where Nation = 1 and Loyalty < @KNP order by LoyaltyMonthly desctruncate table nphumaninsert nphuman select top 30 strUserID, Loyalty, LoyaltyMonthly from USERDATA where Nation = 2 and Loyalty < @HNP order by LoyaltyMonthly descdeclare @Karusa varchar(21),@Karusb varchar(21), @Karusc varchar(21), @Karusd varchar(21), @Karuse varchar(21), @Karusf varchar(21), @Karusg varchar(21), @Karush varchar(21),@Karusi varchar(21),@Karusj varchar(21),@Karusk varchar(21), @Karusl varchar(21),@Karusm varchar(21),@Karusn varchar(21),@Karusu varchar(21),@Karusv varchar(21),@Karusy varchar(21),@Karusx varchar(21),@Karusw varchar(21),@Karusz varchar(21),@Karusab varchar(21),@Karusac varchar(21),@Karusad varchar(21),@Karusae varchar(21),@Karusaf varchar(21),@Karusag varchar(21), @Karusah varchar(21),@Karusai varchar(21),@Karusaj varchar(21),@Karusak varchar(21),@Elmoa varchar(21), @Elmob varchar(21), @Elmoc varchar(21), @Elmod varchar(21), @Elmoe varchar(21), @Elmof varchar(21), @Elmog varchar(21), @Elmoh varchar(21), @Elmoi varchar(21), @Elmoj varchar(21), @Elmok varchar(21), @Elmol varchar(21), @Elmom varchar(21), @Elmon varchar(21), @Elmou varchar(21),@Elmov varchar(21), @Elmoy varchar(21), @Elmox varchar(21), @Elmow varchar(21), @Elmoz varchar(21),@Elmoab varchar(21), @Elmoac varchar(21), @Elmoad varchar(21),@Elmoae varchar(21), @Elmoaf varchar(21),@Elmoag varchar(21), @Elmoah varchar(21), @Elmoai varchar(21), @Elmoaj varchar(21), @Elmoak varchar(21)select @Karusa = strUserID from npkarus where nRank = 1select @Karusb = strUserID from npkarus where nRank = 2select @Karusc = strUserID from npkarus where nRank = 3select @Karusd = strUserID from npkarus where nRank = 4select @Karuse = strUserID from npkarus where nRank = 5select @Karusf = strUserID from npkarus where nRank = 6select @Karusg = strUserID from npkarus where nRank = 7select @Karush = strUserID from npkarus where nRank = 8select @Karusi = strUserID from npkarus where nRank = 9select @Karusj = strUserID from npkarus where nRank = 10select @Karusk = strUserID from npkarus where nRank = 11select @Karusl = strUserID from npkarus where nRank = 12select @Karusm = strUserID from npkarus where nRank = 13select @Karusn = strUserID from npkarus where nRank = 14select @Karusu = strUserID from npkarus where nRank = 15select @Karusv = strUserID from npkarus where nRank = 16select @Karusy = strUserID from npkarus where nRank = 17select @Karusx = strUserID from npkarus where nRank = 18select @Karusw = strUserID from npkarus where nRank = 19select @Karusz = strUserID from npkarus where nRank = 20select @Karusab = strUserID from npkarus where nRank = 21select @Karusac = strUserID from npkarus where nRank = 22select @Karusad = strUserID from npkarus where nRank = 23select @Karusae = strUserID from npkarus where nRank = 24select @Karusaf = strUserID from npkarus where nRank = 25select @Karusag = strUserID from npkarus where nRank = 26select @Karusah = strUserID from npkarus where nRank = 27select @Karusai = strUserID from npkarus where nRank = 28select @Karusaj = strUserID from npkarus where nRank = 29select @Karusak = strUserID from npkarus where nRank = 30select @Elmoa = strUserID from nphuman where nRank = 1select @Elmob = strUserID from nphuman where nRank = 2select @Elmoc = strUserID from nphuman where nRank = 3select @Elmod = strUserID from nphuman where nRank = 4select @Elmoe = strUserID from nphuman where nRank = 5select @Elmof = strUserID from nphuman where nRank = 6select @Elmog = strUserID from nphuman where nRank = 7select @Elmoh = strUserID from nphuman where nRank = 8select @Elmoi = strUserID from nphuman where nRank = 9select @Elmoj = strUserID from nphuman where nRank = 10select @Elmok = strUserID from nphuman where nRank = 11select @Elmol = strUserID from nphuman where nRank = 12select @Elmom = strUserID from nphuman where nRank = 13select @Elmon = strUserID from nphuman where nRank = 14select @Elmou = strUserID from nphuman where nRank = 15select @Elmov = strUserID from nphuman where nRank = 16select @Elmoy = strUserID from nphuman where nRank = 17select @Elmox = strUserID from nphuman where nRank = 18select @Elmow = strUserID from nphuman where nRank = 19select @Elmoz = strUserID from nphuman where nRank = 20select @Elmoab = strUserID from nphuman where nRank = 21select @Elmoac = strUserID from nphuman where nRank = 22select @Elmoad = strUserID from nphuman where nRank = 23select @Elmoae = strUserID from nphuman where nRank = 24select @Elmoaf = strUserID from nphuman where nRank = 25select @Elmoag = strUserID from nphuman where nRank = 26select @Elmoah = strUserID from nphuman where nRank = 27select @Elmoai = strUserID from nphuman where nRank = 28select @Elmoaj = strUserID from nphuman where nRank = 29select @Elmoak = strUserID from nphuman where nRank = 30/* Güncelleme Yapıyoruz */update user_personal_rank set strElmoUserID = @Elmoa, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoa), strKarusUserID = @karusa, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusa) where nRank = 1update user_personal_rank set strElmoUserID = @Elmob, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmob), strKarusUserID = @karusb, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusb) where nRank = 2update user_personal_rank set strElmoUserID = @Elmoc, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoc), strKarusUserID = @karusc, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusc) where nRank = 3update user_personal_rank set strElmoUserID = @Elmod, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmod), strKarusUserID = @karusd, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusd) where nRank = 4update user_personal_rank set strElmoUserID = @Elmoe, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoe), strKarusUserID = @karuse, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karuse) where nRank = 5update user_personal_rank set strElmoUserID = @Elmof, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmof), strKarusUserID = @karusf, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusf) where nRank = 6update user_personal_rank set strElmoUserID = @Elmog, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmog), strKarusUserID = @karusg, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusg) where nRank = 7update user_personal_rank set strElmoUserID = @Elmoh, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoh), strKarusUserID = @karush, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karush) where nRank = 8update user_personal_rank set strElmoUserID = @Elmoi, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoi), strKarusUserID = @karusi, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusi) where nRank = 9update user_personal_rank set strElmoUserID = @Elmoj, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoj), strKarusUserID = @karusj, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusj) where nRank = 10update user_personal_rank set strElmoUserID = @Elmok, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmok), strKarusUserID = @karusk, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusk) where nRank = 11update user_personal_rank set strElmoUserID = @Elmol, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmol), strKarusUserID = @karusl, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusl) where nRank = 12update user_personal_rank set strElmoUserID = @Elmom, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmom), strKarusUserID = @karusm, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusm) where nRank = 13update user_personal_rank set strElmoUserID = @Elmon, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmon), strKarusUserID = @karusn, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusn) where nRank = 14update user_personal_rank set strElmoUserID = @Elmou, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmou), strKarusUserID = @karusu, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusu) where nRank = 15update user_personal_rank set strElmoUserID = @Elmov, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmov), strKarusUserID = @karusv, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusv) where nRank = 16update user_personal_rank set strElmoUserID = @Elmoy, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoy), strKarusUserID = @karusy, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusy) where nRank = 17update user_personal_rank set strElmoUserID = @Elmox, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmox), strKarusUserID = @karusx, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusx) where nRank = 18update user_personal_rank set strElmoUserID = @Elmow, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmow), strKarusUserID = @karusw, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusw) where nRank = 19update user_personal_rank set strElmoUserID = @Elmoz, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoz), strKarusUserID = @karusz, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusz) where nRank = 20update user_personal_rank set strElmoUserID = @Elmoab, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoab), strKarusUserID = @karusab, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusab) where nRank = 21update user_personal_rank set strElmoUserID = @Elmoac, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoac), strKarusUserID = @karusac, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusac) where nRank = 22update user_personal_rank set strElmoUserID = @Elmoad, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoad), strKarusUserID = @karusad, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusad) where nRank = 23update user_personal_rank set strElmoUserID = @Elmoae, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoae), strKarusUserID = @karusae, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusae) where nRank = 24update user_personal_rank set strElmoUserID = @Elmoaf, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoaf), strKarusUserID = @karusaf, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusaf) where nRank = 25update user_personal_rank set strElmoUserID = @Elmoag, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoag), strKarusUserID = @karusag, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusag) where nRank = 26update user_personal_rank set strElmoUserID = @Elmoah, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoah), strKarusUserID = @karusah, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusah) where nRank = 27update user_personal_rank set strElmoUserID = @Elmoai, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoai), strKarusUserID = @karusai, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusai) where nRank = 28update user_personal_rank set strElmoUserID = @Elmoaj, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoaj), strKarusUserID = @karusaj, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusaj) where nRank = 29update user_personal_rank set strElmoUserID = @Elmoak, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoak), strKarusUserID = @karusak, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusak) where nRank = 30GO

Buraya kadar herşey tamam. Şimdik gelelim otomatik yapmaya diyelimki 20:30 'da simgeler güncellenecek. Resimlerdekini adım adım uygulayın.

[Resimleri görebilmek için üye olun veya giriş yapın.]

This image has been resized. Click this bar to view the full image. The original image is sized 1024x454 and weights 106KB.

[Resimleri görebilmek için üye olun veya giriş yapın.]

This image has been resized. Click this bar to view the full image. The original image is sized 1024x572 and weights 103KB.

[Resimleri görebilmek için üye olun veya giriş yapın.]

[Resimleri görebilmek için üye olun veya giriş yapın.]

This image has been resized. Click this bar to view the full image. The original image is sized 1024x581 and weights 98KB.

[Resimleri görebilmek için üye olun veya giriş yapın.]

This image has been resized. Click this bar to view the full image. The original image is sized 1024x580 and weights 105KB.

Zamanı belirledikten sonra "Tamam" Diyoruz. 2 kez İleri diyoruz . Job ismini belirliyoruz. Son Diyoruz.

Son olarak ;
Başlat > Tüm Programlar > Microsoft SQL Server > Service Manager'den
2.Sekmeden SQLServerAgent'i seçip Start Diyoruz.

GÖRÜPTE YORUM YAZMAYAN VE BUNU PAYLAŞIPTA KENDİ İSMİNİ VEREN TOPTUR.GÖRMEYEYİM x)