bluesky089
08-11-11, 09:08 PM
Như tiêu đề. Em xin cái Query xóa tài khỏan lâu ngày ko đăng nhập.
Tài khoản ko có nhân vật.
Em xài SCF
Em có thử chạy Query bên Lưu trữ. Nhưng báo lỗi:
Server: Msg 446, Level 16, State 9, Line 1
Cannot resolve collation conflict for equal to operation.
Query:
delete from memb_info where memb___id not in ( select memb___id from memb_stat) delete from accountcharacter where id not in ( select memb___id from memb_stat) delete from character where accountid not in ( select memb___id from memb_stat) delete from warehouse where accountid not in ( select memb___id from memb_stat)
Tài khoản ko có nhân vật.
Em xài SCF
Em có thử chạy Query bên Lưu trữ. Nhưng báo lỗi:
Server: Msg 446, Level 16, State 9, Line 1
Cannot resolve collation conflict for equal to operation.
Query:
delete from memb_info where memb___id not in ( select memb___id from memb_stat) delete from accountcharacter where id not in ( select memb___id from memb_stat) delete from character where accountid not in ( select memb___id from memb_stat) delete from warehouse where accountid not in ( select memb___id from memb_stat)