金蝶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
操作前必须备份账套!无备份自负!