killermu
02/10/2015, 06:08 PM
Crie essa job pra rodar a cada hora online ganha 6 WCoinC
UPDATE GameShop_Data SET WCoinC = WCoinC+6
FROM MEMB_INFO JOIN MEMB_STAT ON MEMB_INFO.memb___id = MEMB_STAT.memb___id COLLATE Latin1_general_CI_AI
WHERE (ConnectStat >= 1)
Obs: estou usando ela na minha s8.2
UPDATE GameShop_Data SET WCoinC = WCoinC+6
FROM MEMB_INFO JOIN MEMB_STAT ON MEMB_INFO.memb___id = MEMB_STAT.memb___id COLLATE Latin1_general_CI_AI
WHERE (ConnectStat >= 1)
Obs: estou usando ela na minha s8.2