博主 金蝶K3 WISE 清理用户异常SQL处理语句
[全站通告] 想快速节省您的时间并可接受付费的朋友，可扫右边二维码加博主微信-非诚勿扰！
有时单独某一个用户查询有问题，或者显示报表有问题之类的，可以尝试使用语句处理下
执行语句前，建议备份数据再操作
delete from t_UserProfile where FUserID in (select FUserID from t_User where FName='用户名') delete from ICClassUserProfile where FUserID in (select FUserID from t_User where FName='用户名') delete from ICUserTemplateEntry where FUserID in (select FUserID from t_User where FName='用户名') delete from ICClassToolBarProfile where FUserID in (select FUserID from t_User where FName='用户名')
