Cum stergi conturile goale Automat

NaRuTo' · Trimis: 18/02/2008 02:11 Titlul subiectului: Cum stergi conturile goale Automat

intri in Start/Programs/Microsoft SQL Server/Query Analyzer :dots:

va logati
selectati database MuOnline loati codurile de mai :thumbsdown:

.. pe rand .. u :no:

l cate u

l cu copy paste iar pentru a le rula .. dati refresh .. F5 .. cel mai simplu

Codurile :

alter table memb_info

add active int

alter table VI_CURR_INFO

add active int

Atentie aceste coduri de mai :thumbsup:

le rulati o singura data :!:

Daka mai vreti alta data sa stergeti conturile goale folositi ori de cate ori vreti pe cele de mai de :thumbsdown:

:

Update dbo.memb_info

SET active = 0

Update dbo.memb_info

SET active = 1 FROM memb_info join Character on memb_info.memb___id=Character.AccountID

collate Latin1_general_CI_AS

Update dbo.VI_CURR_INFO

SET active = 0

Update dbo.VI_CURR_INFO

SET active = 1 FROM VI_CURR_INFO join Character on VI_CURR_INFO.memb___id=Character.AccountID

collate Latin1_general_CI_AS

SELECT * FROM VI_CURR_INFO join MEMB_INFO on VI_CURR_INFO.memb___id=MEMB_INFO.memb___id

collate Latin1_general_CI_AS WHERE memb_info.active = 0 AND VI_CURR_INFO.active=0

DELETE FROM VI_CURR_INFO WHERE VI_CURR_INFO.active=0

DELETE FROM MEMB_INFO WHERE memb_info.active = 0
_________________
By NaRuTo Cum stergi conturile goale Automat Cum stergi conturile goale Automat

Cum stergi conturile goale Automat Cum stergi conturile goale Automat