Kod:
INSERT INTO [ITEM] Values (800003000,'Scroll of Strength(L) (+0)',255,15,0,0,0,0,0,1,30,2000,0,0,0,500023,0,1, 99,0,0,15,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [ITEM] Values (800004000,'Scroll of Health(L) (+0)',255,15,0,0,0,0,0,1,30,2000,0,0,0,500024,0,1, 99,0,0,0,15,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [ITEM] Values (800005000,'Scroll of Dexterity(L) (+0)',255,15,0,0,0,0,0,1,30,2000,0,0,0,500025,0,1, 99,0,0,0,0,15,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [ITEM] Values (800006000'Scroll of inteligence(L) (+0)',255,15,0,0,0,0,0,1,30,2000,0,0,0,500026,0,1, 99,0,0,0,0,0,15,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [ITEM] Values (800007000'Scroll of Magic power(L) (+0)',255,15,0,0,0,0,0,1,30,2000,0,0,0,500027,0,1, 99,0,0,0,0,0,0,15,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [ITEM] Values (800078000,'HP Scroll 2000(L) (+0)',255,15,0,0,0,0,0,1,30,2000,0,0,0,500031,0,2, 99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [ITEM] Values (800076000,'Scroll of Armor 350 (+0)',255,15,0,0,0,0,0,1,30,2000,0,300,0,500030,0, 30,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [ITEM] Values (910126303,'Shield of (+3)',60,2,0,0,0,100,20,200,10000,8497 4, 0,197,0,0,0,1,99,0,0,98,0,0,0,0,0,4,0,0,0,26,26,26 ,26,0,0,0,0,0,0,0,0,0,0,3,3,3,3,0,0,0,6,6,6,0,0,0)
INSERT INTO [ITEM] Values (800015000,'Speed-Up Potion (+0)',255,15,0,0,0,0,0,1,30,2000,0,0,0,500035,0,1, 99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [ITEM] Values (800014000',Scroll of Attack (+0)',255,15,0,0,0,0,0,1,30,2000,0,0,0,500034,0,1, 99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
Kullanımı ...
1 Başlat > Tüm Programlar > Microsoft SQL Server > Query Analyzer ‘ a giriyoruz.
2 SQL Server’ a bağlanıyoruz ve açılan ekranda ” master ” yerine ” DBmizi ” seçiyoruz.
3 Seçtikten sonra aşağıdaki kodu kopyalayıp , yapıştırıyoruz ve F5 yaparak kodumuzu uyguluyoruz.
Alıntı Arkadaşlar Denemedim
INSERT INTO [ITEM] Values (800003000,'Scroll of Strength(L) (+0)',255,15,0,0,0,0,0,1,30,2000,0,0,0,500023,0,1, 99,0,0,15,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [ITEM] Values (800004000,'Scroll of Health(L) (+0)',255,15,0,0,0,0,0,1,30,2000,0,0,0,500024,0,1, 99,0,0,0,15,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [ITEM] Values (800005000,'Scroll of Dexterity(L) (+0)',255,15,0,0,0,0,0,1,30,2000,0,0,0,500025,0,1, 99,0,0,0,0,15,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [ITEM] Values (800006000'Scroll of inteligence(L) (+0)',255,15,0,0,0,0,0,1,30,2000,0,0,0,500026,0,1, 99,0,0,0,0,0,15,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [ITEM] Values (800007000'Scroll of Magic power(L) (+0)',255,15,0,0,0,0,0,1,30,2000,0,0,0,500027,0,1, 99,0,0,0,0,0,0,15,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [ITEM] Values (800078000,'HP Scroll 2000(L) (+0)',255,15,0,0,0,0,0,1,30,2000,0,0,0,500031,0,2, 99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [ITEM] Values (800076000,'Scroll of Armor 350 (+0)',255,15,0,0,0,0,0,1,30,2000,0,300,0,500030,0, 30,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [ITEM] Values (910126303,'Shield of (+3)',60,2,0,0,0,100,20,200,10000,8497 4, 0,197,0,0,0,1,99,0,0,98,0,0,0,0,0,4,0,0,0,26,26,26 ,26,0,0,0,0,0,0,0,0,0,0,3,3,3,3,0,0,0,6,6,6,0,0,0)
INSERT INTO [ITEM] Values (800015000,'Speed-Up Potion (+0)',255,15,0,0,0,0,0,1,30,2000,0,0,0,500035,0,1, 99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [ITEM] Values (800014000',Scroll of Attack (+0)',255,15,0,0,0,0,0,1,30,2000,0,0,0,500034,0,1, 99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
Kullanımı ...
1 Başlat > Tüm Programlar > Microsoft SQL Server > Query Analyzer ‘ a giriyoruz.
2 SQL Server’ a bağlanıyoruz ve açılan ekranda ” master ” yerine ” DBmizi ” seçiyoruz.
3 Seçtikten sonra aşağıdaki kodu kopyalayıp , yapıştırıyoruz ve F5 yaparak kodumuzu uyguluyoruz.
Alıntı Arkadaşlar Denemedim