金蝶KIS专业版常用SQL语句分享,博主常用语句

[全站通告] 想快速节省您的时间并可接受付费的朋友,可扫右边二维码加博主微信-非诚勿扰!

操作前必须备份账套!后续其他语句慢慢更新到此文章上,有需要的伙伴可以收藏此网址 CTRL+D

--清空密码
update t_User set FSID = '' where FName = 'Manager'
go
--取消密码策略
update t_SystemProfile set FValue=0 where FKey in ('FirstLogin','FiveLock','RecentThree','PassWordComplexity','MinPassWordLength')
go
--密码始终有效(所有用户)
UPDATE t_user SET FUInValidDate='1900-01-01 00:00:00.000',FPwValidDay=0
go
--清空离线密码
update t_users set FPassword = null where FName='Admin'update t_users set FPassword = null where FName='Admin'
go
--添加反过账
DELETE FROM t_SystemProfile WHERE FKey='unPosKey'
INSERT INTO t_SystemProfile (FCategory, FKey, FValue, FReadonly, FDescription, FLevel, FExplanation, FFormat, FSort, FDescription_cht, FDescription_en)
VALUES ('General', 'unPosKey', '1', 0, '', ' ', ' ', '', 1, '', '')
GO
UPDATE t_objectaccesstype SET FObjectID=0 WHERE FObjectType=4 AND FObjectID=-1 AND fname='反过账'
GO
--根据用户名清除用户配置表(清理用户异常)
delete t_userprofile where fuserid =(select fuserid from t_user where fname='manager')
--修改启用期间
UPDATE t_SystemProfile SET FValue = 0 WHERE (FCategory = 'gl') AND (FKey = 'Closed')
--删除全部科目 (用于重新导入科目)
delete t_account

操作前必须备份账套!无备份自负!

发表回复

加入本站SVIP会员,海量资源免费查看下载

目前为止共有167位优秀的SVIP会员加入! 立即加入!