常用语句

时间:2023-12-04 浏览:4496 分类:未命名

向日葵下载地址:https://sunlogin.oray.com/download?categ=ent

插件:https://help.ppinsoft.cn/plugin/plugin.html


允许全文索引: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


https://www.piqsels.com/


条件: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'