Çin astrolojisi : Mesaj Sayısı : 1340 Kayıt tarihi : 20/08/09 Yaş : 31
Nerden : Ankara
CREATE PROCEDURE f5AS-- ilk 5 g0 ve g1 ---5 ile 10 arası g2---10 ile 15 arası g3---diğerleri nplerine göredir.--- [Linkleri görebilmek için üye olun veya giriş yapın.] / IZeeupdate knights set points = '999999',ranking = '1'where idname = (Select strname from KNIGHTS_RATING where nrank = 5)update knights set points = 750000 where ranking=1update knights set points = 750000 where ranking=2update knights set points = 750000 where ranking=3update knights set points = 750000 where ranking=4update knights set points = 750000 where ranking=5update knights set points = 350000 where idname = (Select strname from KNIGHTS_RATING where nrank = 6)update knights set points = 350000 where idname = (Select strname from KNIGHTS_RATING where nrank = 7)update knights set points = 350000 where idname = (Select strname from KNIGHTS_RATING where nrank = update knights set points = 350000 where idname = (Select strname from KNIGHTS_RATING where nrank = 9)update knights set points = 350000 where idname = (Select strname from KNIGHTS_RATING where nrank = 10)update knights set points = 150000 where idname = (Select strname from KNIGHTS_RATING where nrank = 11)update knights set points = 150000 where idname = (Select strname from KNIGHTS_RATING where nrank = 12)update knights set points = 150000 where idname = (Select strname from KNIGHTS_RATING where nrank = 13)update knights set points = 150000 where idname = (Select strname from KNIGHTS_RATING where nrank = 14)update knights set points = 150000 where idname = (Select strname from KNIGHTS_RATING where nrank = 15)GO