向日葵下载地址:https://sunlogin.oray.com/download?categ=ent
允许全文索引:EXEC sp_fulltext_database 'enable'
设置自动备份:backup database [hibole-2] to disk ='E:\hibole bak\backup.bak' with init
设置所有的list 防止下载:update zplistinfo set nocopyright=1
超级管理员解锁: update a01 set loginerrcnt=0
全部项目共享:update keyproject set share=1
全部项目不共享:update keyproject set share=0
全部客户共享:update keycustomer set share=1
全部客户不共享:update keycustomer set share=0
select count(1) from a01 where a0191=1
select count(1) from zpresumeinfo
https://dl.todesk.com/windows/ToDesk_Lite.exe
C:\Windows\System32\winevt\Logs
C:\inetpub\logs\LogFiles
C:\Windows\Temp
update ysysparams set paramvalue='1' where ParamName='Phone028Flag'
加强:update ysysparams set paramvalue='1' where paramname in ('FileAutoShowMFlag','CVIsExistsFlag','CVIsExistsFlag1')
http://shujudaping.ppinsoft.cn:5681/linghang/index.html
条件:update ySysParams set ParamValue='1' where ParamName='UserQuickFilterFlag'
show colleges resigned: update ySysParams set ParamValue='1' where ParamName='NoteSearchFlag'
不能自动生成简历原件:***/file/getwxhtmlpageotherparams
查看简历文件夹的情况:select * from zpresumeinfofolder
看一下文件夹的ID是什么
把没有放到文件夹的简历转移到某个文件夹:update zpresumeinfo set folderid='0002' where folderid is null or folderid=''
转移LIST文件
select * from zplistinfofolder
看一下文件夹的ID是什么
把没有放到LIST文件夹的LIST转移到某个文件夹:update zplistinfo set folderid='0011' where folderid is null or folderid=''
转移客户
select * from Keycustomerfolder
看一下文件夹的ID是什么
update Keycustomer set folderid='0002' where folderid is null or folderid=''
路径查询:
select * from HuaWeiRecord where recordFileDownloadUrl is not null and recordFileDownloadUrl like '%8989898989%'
update HuaWeiRecord set recordFileDownloadUrl=replace(recordFileDownloadUrl,'E:' ,'C:' )
update HuaWeiRecord set recordFileDownloadUrl=replace(recordFileDownloadUrl,"C:","D:")
EDGE插件下载地址:微软插件
the url to nab a crx file from edge store:edge store
文件名(在IIS中的所有配置都保存在这个文件中):applicationHost.config
路径:C:\Windows\System32\inetsrv\config
delete from a01 where a0188<>-99
delete from zpresumeinfo
delete from keyproject
delete from keycustomer
delete from Saas_CDR
delete from KeyMailNote
delete from OACalendar_Task
delete from OACalendar_TS
删除城市,行业,职能:
delete from BM_AB
delete from bm_a0203
delete from bm_worktype
English Analysis : update ysysparams set paramvalue='5' where ParamName='AnalysisFlag'
update ysysparams set paramvalue='1d582f89-fa81' where paramname='SystemGUID'
晋ICP备2022011229号 | Powered By Z-BlogPHP 1.7.3