sql
woobol
非主流业余码农
展开
-
泛微OA-测试环境更新所有密码为1
password为md5加密,可以根据自己实际需要修改update hrmresource set password= 'C4CA4238A0B923820DCC509A6F75849B'原创 2019-04-16 14:30:24 · 19970 阅读 · 0 评论 -
泛微OA-年份浏览框增加年份值
INSERT INTO WORKFLOW_FIELDYEAR(YEARID, YEARNAME) SELECT MAX(YEARID)+1 AS YEARID, MAX(YEARID)+1 AS YEARNAME FROM WORKFLOW_FIELDYEAR原创 2019-04-16 14:38:15 · 18049 阅读 · 1 评论 -
泛微OA-根据值定位值所在的表
--SQL server--根据值查询弄个表DECLARE @what varchar(800)SET @what='XXXXXXX' --要搜索的字符串DECLARE @sql varchar(8000)DECLARE TableCursor CURSOR LOCAL FORSELECT sql='IF EXISTS ( SELECT 1 FROM ['+o.name+'] WHER...原创 2019-04-16 15:48:55 · 17820 阅读 · 0 评论 -
泛微OA-流程统计
--按月统计每月流程数--最近6个月数据统计select TOP 6 CONVERT(VARCHAR(7),receivedate,120),COUNT(requestid) from workflow_currentoperatorgroup by CONVERT(VARCHAR(7),receivedate,120)order by CONVERT(VARCHAR(7),receiv...原创 2019-04-16 15:52:15 · 16425 阅读 · 1 评论 -
泛微OA-重装修改盘符
update SystemSet set filesystem = replace(filesystem, 'E:\', 'D:\'), filesystembackup = replace(filesystembackup, 'E:\', 'D:\'), picturePath = replace(picturePath, 'E:\', 'D:\'), emlPath = replace(e...原创 2019-04-16 15:54:56 · 12700 阅读 · 0 评论 -
泛微OA-测试机更改sysadmin密码为1
update HrmResourceManager set password = 'C4CA4238A0B923820DCC509A6F75849B' where loginid = 'sysadmin'原创 2019-04-19 10:01:02 · 19789 阅读 · 0 评论