金蝶K3清除用户信息的SQL语句?

金蝶K3清除用户信息的SQL语句?

概述:
清除用户信息 SQL 语句:
declare @userid3 int
select @userid3=fuserid from t_user where fname=’ 孙 丽 ‘

获取问题用户 ID
delete from t_userprofile where fuserid=@userid3 and
fcategory
like ‘O%’ and fkey=’reg’

注:操作前请先做好账套的备份。