金蝶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’
注:操作前请先做好账套的备份。
金蝶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’
注:操作前请先做好账套的备份。