配置方法是在数据库上建立一个计划，里面写上：update zpresumeinfo set folderid=null where datediff(day,a0117,getdate())>15

regsvr32 D:\V16\bin\LsComServer.dll
regsvr32 C:\V16\bin\LsComServer.dll
regsvr32 C:\招聘软件V16\bin\ldserver.dll

C:\Windows\Microsoft.NET\Framework\v4.0.30319\aspnet_regiis.exe -i

C:\WINDOWS\Microsoft.NET\Framework\v4.0.30319\InstallUtil.exe "D:\Program Files\jlsoft\LsHrNetService.exe"
C:\WINDOWS\Microsoft.NET\Framework\v4.0.30319\InstallUtil.exe "F:\V16\bin\DownloadRecordTool.exe"  
sc delete LsHrNetService
sc delete PPPhoneDownload


regsvr32 "C:\Program Files\jlsoft\sdserver.dll"
regsvr32 "C:\Program Files\jlsoft\CellCtrl5.ocx"

http://note.youdao.com/share/?token=916DC20D64B94E48895C66E513281246&gid=10048118

允许全文索引
EXEC sp_fulltext_database 'enable'

execute sp_fulltext_database 'enable'
backup database [hibole-2] to disk ='E:\hibole bak\backup.bak' with init

干扰词还是会影响全文检索的精度的
解决办法，找到sqlserver安装目录下的FTADATA文件夹下的noiseCHS.txt文件，把里面的内容全部删除后保存
再重建全文检索，就会好很多



execute sp_fulltext_database 'enable'

update zplistinfo set nocopyright=1
设置所有的list 防止下载

超级管理员解锁  update a01 set loginerrcnt=0

全部项目共享：update keyproject set share=1

update ysysparams set paramvalue='1d582f89-fa81' where paramname='SystemGUID'

update ysysparams set paramvalue='33' where ParamName='YinPhoneType'

update keyproject set lastupdatedate=null
直接把更新时间清了
这样新的操作会自动按最上面

update keycustomer set share=1   共享


update keycustomer set share=0   不共享


update keyproject set share=1  共享


update keyproject set share=0  不共享

update ysysparams set paramvalue='33' where ParamName='YinPhoneType'

delete from OACalendar_Task
delete from OACalendar_TS
删除提醒
删除邮箱 delete from KeyMailNote

select * from HuaWeiRecord where recordFileDownloadUrl <> 'NULL'     查找录音所在文件夹

备注超过1000字
select count(1) from a01 where a0191=1
select * from a01 where a0191=1
改离职：update a01 set a0191=4 where a0188=750


关机：-s –f -t 30

update ysysparams set paramvalue='31' where paramname='PassWordOfAdmin'

select count(1) from a01 where a0191=1

select pname from keyproject

雅洁包启用隐藏客户名称功能：update  ySysParams set ParamValue='1' where ParamName='CustomerSecrecyFlag'

开启最新英文解析，要执行update ysysparams set paramvalue='5' where ParamName='AnalysisFlag'，一般客户没有要求或是没有很多英文简历，不启用

超大附件：update ysysparams set paramvalue='1' where paramname='UpBigFileFlag'

C:\Users\Administrator\AppData\Local\Google\Chrome\User Data\Default
文件名 Secure Preferences 只读去掉

wmic  cpu get NumberOfCores

update a01 set loginerrcnt=0 where A0190 = 'admin'
delete from KeyCVPRCUCnt

update zpresumeinfo set active = 0 where A0124='大专'

update a01 set loginerrcnt=0 where a0188=-99        解锁ADMIN

select count(1) from zpresumeinfo    查库里有多少简历

路径查询：
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:")

如果需要最强判重(自有服务器一般可以执行，品聘云上库不是太大的经常反应判重问题的可执行) sql:update ysysparams set paramvalue='1' where paramname in ('FileAutoShowMFlag','CVIsExistsFlag','CVIsExistsFlag1')

批量把离职的人放到一个部门里
select dept_code,* from b01
update a01 set dept_code='xxx' where a0191=4

批量导入时候手机邮箱都查重：update ysysparams set ParamValue='2' where ParamName='InputCVRepeatFlag'

查询部门	select Dept_Code,Content from B01
修改Administrator账号部门	update A01 set Dept_Code='1003' where A0188 ='-99'

update ySysParams set  ParamValue='1' where ParamName='UserQuickFilterFlag'    启用人才条件

update ysysparams set paramvalue='1' where paramname='PhoneClassFlag'  启用电话选择运营商

条件：update ySysParams set  ParamValue='1' where ParamName='UserQuickFilterFlag'