{ "format": "wb-todo-workbench", "formatVersion": 1, "app": "个人工作台", "rev": 361, "savedAt": "2026-09-20 17:26:12", "state": { "tasks": [ { "id": "T-002", "title": "数据库变更工具有问题：「这个字段是唯一…」（宋宇杰提）", "cat": "空数据库", "pri": "中", "due": "2026-09-18", "status": "已完成", "note": "原文被截断，待补全", "star": false, "created": "2026-09-17", "detail": "", "att": [], "done": "2026-09-18" }, { "id": "T-003", "title": "标准看板 V4 组织配置", "cat": "空数据库", "pri": "中", "due": "2026-09-30", "status": "进行中", "note": "", "star": true, "created": "2026-09-17", "detail": "", "att": [] }, { "id": "T-004", "title": "操作台模板梳理", "cat": "空数据库", "pri": "中", "due": "2026-10-18", "status": "待启动", "note": "", "star": true, "created": "2026-09-17", "detail": "", "att": [] }, { "id": "T-005", "title": "草案与审批草案两个逻辑微调（罗志昊提）", "cat": "空数据库", "pri": "中", "due": "2026-09-21", "status": "进行中", "note": "原文被截断，待补全", "star": false, "created": "2026-09-17", "detail": "", "att": [] }, { "id": "T-006", "title": "销售退货通知：不能超过订单已发货数量（丰冰提）", "cat": "空数据库", "pri": "中", "due": "2026-09-21", "status": "待确认", "note": "原文被截断，待补全", "star": false, "created": "2026-09-17", "detail": "", "att": [] }, { "id": "T-007", "title": "DocDate 命名：HOME 列表是凭证日期，新增单据是…（陈辉提）", "cat": "空数据库", "pri": "中", "due": "2026-09-25", "status": "待确认", "note": "原文被截断，待补全", "star": false, "created": "2026-09-17", "detail": "", "att": [] }, { "id": "T-008", "title": "多组织分录号链接方案，参考考晟…（马康凌提）", "cat": "空数据库", "pri": "中", "due": "2026-09-22", "status": "待确认", "note": "原文被截断，待补全", "star": false, "created": "2026-09-17", "detail": "", "att": [] }, { "id": "T-009", "title": "供应商和客户自动编码：需要 4 位流水，3 位不够用（马康凌提）", "cat": "空数据库", "pri": "中", "due": "2026-09-20", "status": "待启动", "note": "", "star": false, "created": "2026-09-17", "detail": "", "att": [] }, { "id": "T-010", "title": "base 字段是否有必要全部设为可复制（马康凌提）", "cat": "空数据库", "pri": "中", "due": "2026-09-21", "status": "待确认", "note": "原文被截断，待补全", "star": false, "created": "2026-09-17", "detail": "", "att": [] }, { "id": "T-014", "title": "信息化跟踪仪表板未完善完成", "cat": "空数据库", "pri": "中", "due": "2026-09-25", "status": "待启动", "note": "来源：调整记录2609 第3条", "star": false, "created": "2026-09-17", "detail": "", "att": [] }, { "id": "T-015", "title": "打印样式中有 Select *", "cat": "空数据库", "pri": "中", "due": "2026-09-30", "status": "待启动", "note": "来源：调整记录2609 第4条", "star": false, "created": "2026-09-17", "detail": "", "att": [] }, { "id": "T-016", "title": "来料检验、制程检验、出货检验等标配打印样式", "cat": "空数据库", "pri": "中", "due": "2026-10-09", "status": "待启动", "note": "来源：调整记录2609 第5条", "star": false, "created": "2026-09-17", "detail": "", "att": [] }, { "id": "T-017", "title": "是否增加生产与采购回复交期的字段以及方案", "cat": "空数据库", "pri": "中", "due": "2026-10-18", "status": "待启动", "note": "待讨论；来源：调整记录2609 第6条", "star": false, "created": "2026-09-17", "detail": "", "att": [] }, { "id": "T-018", "title": "物料采购、生产、仓库的批量变更工具，优先考虑自定义业务导入更新", "cat": "空数据库", "pri": "中", "due": "2026-10-18", "status": "待启动", "note": "来源：调整记录2609 第7条", "star": false, "created": "2026-09-17", "detail": "", "att": [] }, { "id": "T-019", "title": "BOM 上批量变更计件单价、制造批量、标准作业时间", "cat": "空数据库", "pri": "中", "due": "2026-10-18", "status": "待启动", "note": "来源：调整记录2609 第8条", "star": false, "created": "2026-09-17", "detail": "", "att": [] }, { "id": "T-020", "title": "供应商、客户及一些常用表单，HOME 列表默认增加草稿列表和审批列表", "cat": "空数据库", "pri": "中", "due": "2026-09-30", "status": "待启动", "note": "来源：调整记录2609 第9条", "star": false, "created": "2026-09-17", "detail": "", "att": [] }, { "id": "T-011", "title": "请购单引用销售订单报错（丰冰提）", "cat": "空数据库", "pri": "中", "due": "2026-09-18", "status": "已完成", "note": "截图卡片绿勾 ✓", "star": false, "created": "2026-09-17", "done": "2026-09-17前", "detail": "", "att": [] }, { "id": "T-012", "title": "参数的 DocDate 是过账日期、查询里是凭证日期（陈辉提）", "cat": "空数据库", "pri": "中", "due": "2026-09-18", "status": "已完成", "note": "截图卡片绿勾 ✓", "star": false, "created": "2026-09-17", "done": "2026-09-17前", "detail": "", "att": [] }, { "id": "T-013", "title": "其它出入库单明细-查询报错（陈辉提）", "cat": "空数据库", "pri": "中", "due": "2026-09-18", "status": "已完成", "note": "截图卡片绿勾 ✓", "star": false, "created": "2026-09-17", "done": "2026-09-17前", "detail": "", "att": [] }, { "id": "T-021", "title": "SOralD 设必填，避免直送等单据漏字段；订单类与出入库类已设为必填", "cat": "空数据库", "pri": "中", "due": "2026-09-18", "status": "已完成", "note": "调整记录2609 第1条，绿色高亮", "star": false, "created": "2026-09-17", "done": "2026-09-17前", "detail": "", "att": [] }, { "id": "T-022", "title": "批次余额表查询中，无效的自定义字段语句", "cat": "空数据库", "pri": "中", "due": "2026-09-18", "status": "已完成", "note": "调整记录2609 第2条，绿色高亮", "star": false, "created": "2026-09-17", "done": "2026-09-17前", "detail": "", "att": [] }, { "id": "T-023", "title": "请购单凭证性质去掉「测试1」", "cat": "空数据库", "pri": "中", "due": "2026-09-18", "status": "已完成", "note": "调整记录2609 第11条，绿色高亮", "star": false, "created": "2026-09-17", "done": "2026-09-17前", "detail": "", "att": [] }, { "id": "T-024", "title": "批次余额表、库存余额表，仓库参数支持多选", "cat": "空数据库", "pri": "中", "due": "2026-09-18", "status": "已完成", "note": "调整记录2609 第12条，绿色高亮", "star": false, "created": "2026-09-17", "done": "2026-09-17前", "detail": "", "att": [] }, { "id": "T-025", "title": "物料列表、物料列表树型，显示冻结、启用维度信息", "cat": "空数据库", "pri": "中", "due": "2026-09-18", "status": "已完成", "note": "调整记录2609 第13条，绿色高亮", "star": false, "created": "2026-09-17", "done": "2026-09-17前", "detail": "", "att": [] }, { "id": "T-001", "title": "数据字典缺少部分字段的数据库同步（刘双提）", "cat": "空数据库", "pri": "中", "due": "2026-09-18", "status": "已完成", "note": "锴哥指定：刘双提出的条目标为完成", "star": false, "created": "2026-09-17", "done": "2026-09-18", "detail": "", "att": [] }, { "id": "T-026", "title": "房鑫: 空数据查询工单成本组成，增加工单凭证性质显示；跳转进领料金额的生产领退料明细[91281eef2]的查询语句有问题——退料使用了日期参数，领料没有使用日期参数，查询跨月工单异常", "cat": "", "pri": "中", "due": "2026-09-23", "status": "待启动", "note": "", "star": false, "created": "2026-09-18", "detail": "", "att": [] }, { "id": "T-027", "title": "MES需要制作Help", "cat": "公共", "pri": "中", "due": "2026-09-25", "status": "进行中", "note": "", "star": true, "created": "2026-09-18", "detail": "MES在帮助中心制作工位机相关操作说明以及OEE说明", "att": [] }, { "id": "T-028", "title": "团队经费：工服以及零食", "cat": "部门", "pri": "中", "due": "2026-09-24", "status": "待启动", "note": "", "star": false, "created": "2026-09-18", "detail": "", "att": [] }, { "id": "T-029", "title": "客户对账问题", "cat": "二开", "pri": "中", "due": "2026-09-30", "status": "待启动", "note": "陈志伟配置", "star": false, "created": "2026-09-18", "detail": "客户发货按明细表， 收款按主表，需配置分配的逻辑，追踪款项", "att": [] }, { "id": "T-030", "title": "MES培训道场事宜", "cat": "公共", "pri": "中", "due": "2026-10-18", "status": "待启动", "note": "", "star": false, "created": "2026-09-18", "detail": "", "att": [] }, { "id": "T-031", "title": "最近产品改进以及计划培训预热", "cat": "公共", "pri": "中", "due": "2026-10-18", "status": "待启动", "note": "", "star": false, "created": "2026-09-18", "detail": "", "att": [] }, { "id": "T-032", "title": "9月新版本APS测试", "cat": "公共", "pri": "中", "due": "2026-09-21", "status": "进行中", "note": "", "star": true, "created": "2026-09-18", "detail": "", "att": [] }, { "id": "T-033", "title": "车销每月分销处收货信息总表：销项空白排查与行查询明细完善", "cat": "项目", "pri": "中", "due": "", "status": "已完成", "note": "来源：微信对话截图；对应对话末尾绿色已完成的表", "star": false, "created": "2026-09-20", "detail": "微信截图（2026-09-20）：车销模块每月分销处收货信息总表曾出现空白，8月份存在销项空白问题；已调整完善——把查询部分与各单据的行查询连成一行查询的明细（含查询部分及各单据行查询），补全后查询功能完整、不再欠完善。", "att": [] }, { "id": "T-034", "title": "空数据库：应付发票明细里付款日期为 NULL，这个小地方可能要改一下（周振提）", "cat": "空数据库", "pri": "中", "due": "", "status": "待启动", "note": "", "star": false, "created": "2026-09-20", "detail": "原文：锴哥，空数据库（应付发票明细里付款日期为NULL）的这个小地方可能要改一下。—— 2026-09-20 周振微信原文，未说具体改法，待跟进确认。", "att": [] }, { "id": "T-035", "title": "机器作业记录：新增界面双下拉易误导，作业类型选择需优化（韦潇英提）", "cat": "空数据库", "pri": "中", "due": "", "status": "待启动", "note": "", "star": false, "created": "2026-09-20", "detail": "韦潇英 2026-09-20 反馈：机器作业记录新增界面有 2 个下拉框，第一个有默认值（是作业类型的主类型），第二个为空，客户误以为第一个下拉就是作业类型。空数据库建议：1、机器作业类型内置几个选项；2、新增作业记录时选作业类型，带出作业类型和主类型，主类型不可修改；3、机器作业类型的菜单名称和列表名称一致。", "att": [] } ], "logs": [ "2026-09-17 建账。分类定为：公共 / 部门 / 二开 / 项目 / 空数据库 / 个人（后续可加）。", "2026-09-17 首批录入：AIO8「空数据库」13 条（10 活账 + 3 归档）。约定：卡片绿勾 ✓ / 文档绿色高亮 = 已完成。", "2026-09-17 补录「空数据库调整记录2609」文档：未高亮第 3~9 条入活账（T-014~T-020），卡片里没有的绿高亮第 1/2/11/12/13 条入归档（T-021~T-025）。", "2026-09-18 锴哥指定「刘双提出的」标为完成：T-001 移入归档。", "2026-09-18 账本结构升级：截止→计划完成日期；新增 ★ 重点、新增日期、完成日期。", "2026-09-18 工作台更名「李锴的个人工作台」；新增「✓ 已完成」独立分类标签、详情说明（可粘贴图片/网址/文件）、附件上传。", "2026-09-18 完成 T-002（完成日期 2026-09-18）：数据库变更工具有问题：「这个字段是唯一…」（宋宇杰提）", "2026-09-18 修改 T-003：计划完成=2026-09-30", "2026-09-18 修改 T-004：计划完成=2026-10-18", "2026-09-18 经小艺（微信）新增 T-026：房鑫: 空数据查询工单成本组成，增加工单凭证性质显示；跳转进领料金额的生产领退料明细[91281eef2]的查询语句有问题——退料使用了日期参数，领料没有使用日期参数，查询跨月工单异常", "2026-09-18 标为重点关注 T-004", "2026-09-18 修改 T-005：计划完成=2026-09-20", "2026-09-18 修改 T-009：计划完成=2026-09-20", "2026-09-18 修改 T-006：计划完成=2026-09-21", "2026-09-18 修改 T-007：计划完成=2026-09-25", "2026-09-18 修改 T-008：计划完成=2026-09-22", "2026-09-18 修改 T-010：计划完成=2026-09-21", "2026-09-18 修改 T-014：计划完成=2026-09-25", "2026-09-18 修改 T-015：计划完成=2026-09-30", "2026-09-18 修改 T-016：计划完成=2026-10-09", "2026-09-18 修改 T-017：计划完成=2026-10-18", "2026-09-18 修改 T-018：计划完成=2026-10-18", "2026-09-18 修改 T-019：计划完成=2026-10-18", "2026-09-18 修改 T-020：计划完成=2026-09-30", "2026-09-18 修改 T-001：计划完成=2026-09-18", "2026-09-18 修改 T-002：计划完成=2026-09-18", "2026-09-18 修改 T-011：计划完成=2026-09-18", "2026-09-18 修改 T-012：计划完成=2026-09-18", "2026-09-18 修改 T-013：计划完成=2026-09-18", "2026-09-18 修改 T-021：计划完成=2026-09-18", "2026-09-18 修改 T-022：计划完成=2026-09-18", "2026-09-18 修改 T-023：计划完成=2026-09-18", "2026-09-18 修改 T-024：计划完成=2026-09-18", "2026-09-18 修改 T-025：计划完成=2026-09-18", "2026-09-18 完成 T-005（完成日期 2026-09-18）：草案与审批草案两个逻辑微调（罗志昊提）", "2026-09-18 重新打开 T-005", "2026-09-18 新增 T-027：MES需要制作Help（★重点）（含详情）", "2026-09-18 新增 T-028：团队经费：工服以及零食", "2026-09-18 新增 T-029：客户对账问题（含详情）", "2026-09-18 修改 T-029：计划完成=2026-09-30", "2026-09-18 新增 T-030：MES培训道场事宜", "2026-09-18 新增 T-031：最近产品改进以及计划培训预热", "2026-09-18 添加快速链接 [内部账套] 管理员资源", "2026-09-18 添加快速链接 [内部账套] 空数据库", "2026-09-18 添加快速链接 [内部账套] 空数据库测试", "2026-09-18 添加快速链接 [内部账套] MESTrain", "2026-09-18 添加快速链接 [内部账套] MESCloud", "2026-09-18 添加快速链接 [内部账套] EKCloud", "2026-09-18 修改 T-031：计划完成=2026-10-18", "2026-09-18 新增 T-032：9月新版本APS测试（★重点）", "2026-09-18 状态改为「进行中」 T-032", "2026-09-18 状态改为「进行中」 T-003", "2026-09-18 新增工具语句 S-01（MySQL）", "2026-09-18 新增工具语句 S-02（MSSQL）", "2026-09-18 新增工具语句 S-03（MySQL）", "2026-09-18 新增工具语句 S-04（MySQL）", "2026-09-18 新增工具语句 S-05（MySQL）", "2026-09-18 新增工具语句 S-06（MySQL）", "2026-09-18 新增工具语句 S-07（MySQL）", "2026-09-18 新增工具语句 S-08（MySQL）", "2026-09-18 新增工具语句 S-09（MySQL）", "2026-09-18 新增工具语句 S-10（MySQL）", "2026-09-18 新增工具语句 S-11（MySQL）", "2026-09-18 新增工具语句 S-12（MySQL）", "2026-09-18 新增工具语句 S-13（MySQL）", "2026-09-18 新增工具语句 S-14（MSSQL）", "2026-09-18 新增工具语句 S-15（MySQL）", "2026-09-18 新增工具语句 S-16（MySQL）", "2026-09-18 新增工具语句 S-17（MSSQL）", "2026-09-18 新增工具语句 S-18（MySQL）", "2026-09-18 新增工具语句 S-19（MySQL）", "2026-09-18 新增工具语句 S-20（MySQL）", "2026-09-18 新增工具语句 S-21（MSSQL）", "2026-09-18 新增工具语句 S-22（MySQL）", "2026-09-18 新增工具语句 S-23（MySQL）", "2026-09-18 修改工具语句 S-23", "2026-09-18 新增工具语句 S-24（MySQL）", "2026-09-18 新增工具语句 S-25（MySQL）", "2026-09-18 新增工具语句 S-26（MySQL）", "2026-09-18 新增工具语句 S-27（MSSQL）", "2026-09-18 新增工具语句 S-28（MSSQL）", "2026-09-18 新增工具语句 S-29（MSSQL）", "2026-09-18 新增工具语句 S-30（MSSQL）", "2026-09-18 新增工具语句 S-31（MSSQL）", "2026-09-18 新增工具语句 S-32（MSSQL）", "2026-09-18 新增工具语句 S-33（MSSQL）", "2026-09-18 新增工具语句 S-34（MSSQL）", "2026-09-18 新增工具语句 S-35（MSSQL）", "2026-09-18 新增工具语句 S-36（MSSQL）", "2026-09-18 新增工具语句 S-37（MSSQL）", "2026-09-18 新增工具语句 S-38（MSSQL）", "2026-09-18 新增工具语句 S-39（MSSQL）", "2026-09-18 新增工具语句 S-40（MSSQL）", "2026-09-18 新增工具语句 S-41（MSSQL）", "2026-09-18 新增工具语句 S-42（MSSQL）", "2026-09-18 新增工具语句 S-43（MSSQL）", "2026-09-18 新增工具语句 S-44（MSSQL）", "2026-09-18 新增工具语句 S-45（MSSQL）", "2026-09-18 新增工具语句 S-46（MSSQL）", "2026-09-18 新增工具语句 S-47（MSSQL）", "2026-09-18 新增工具语句 S-48（MySQL）", "2026-09-18 新增工具语句 S-49（MySQL）", "2026-09-18 新增工具语句 S-50（MySQL）", "2026-09-18 新增工具语句 S-51（MySQL）", "2026-09-18 新增工具语句 S-52（MySQL）", "2026-09-18 新增工具语句 S-53（MSSQL）", "2026-09-18 新增工具语句 S-54（MSSQL）", "2026-09-18 新增工具语句 S-55（MSSQL）", "2026-09-18 新增工具语句 S-56（MySQL）", "2026-09-18 新增工具语句 S-57（MSSQL）", "2026-09-18 新增工具语句 S-58（MSSQL）", "2026-09-18 新增会议室 1502 1502", "2026-09-18 新增会议室 1511 1511", "2026-09-18 新增会议室 1512 1512", "2026-09-18 新增会议室 1513 1513", "2026-09-18 新增会议室 1514 1514", "2026-09-18 新增会议室 1515 1515", "2026-09-18 新增会议室 1516 1516", "2026-09-18 新增会议室 1517 1517", "2026-09-18 新增会议室 1518 1518", "2026-09-18 新增会议室 1611 1611", "2026-09-18 新增会议室 1612 1612", "2026-09-18 新增会议室 1613 1613", "2026-09-18 新增会议室 1614 1614", "2026-09-18 新增会议室 1801 1801", "2026-09-18 新增会议室 1802 1802", "2026-09-18 新增会议室 1803 1803", "2026-09-18 新增会议室 1807 1807", "2026-09-18 新增会议室 1712 1712", "2026-09-18 新增会议室 1713 1713", "2026-09-18 快速分配 8 条", "2026-09-18 添加快速链接 [内部账套] 岗前新人培训", "2026-09-18 新建备忘 M-001", "2026-09-18 添加快速链接 [个人网址] 公司网址", "2026-09-18 添加快速链接 [个人网址] AIO8安装", "2026-09-18 添加快速链接 [个人网址] PDF转换", "2026-09-18 添加快速链接 [个人网址] 矢量图库", "2026-09-18 添加快速链接 [个人网址] 视觉素材", "2026-09-18 新建相册 A-001「测试相册」", "2026-09-18 相册 A-001 改名「测试相册」→「看板」", "2026-09-18 新建相册 A-002「大数据中心」", "2026-09-18 新建相册 A-003「仪表板」", "2026-09-18 新建相册 A-004「现场数据展示」", "2026-09-18 新建相册 A-005「实施现场素材」", "2026-09-18 新建相册 A-006「典型资源素材」", "2026-09-18 新建相册 A-007「标签」", "2026-09-18 新建相册 A-008「站点安装」", "2026-09-18 修改 T-005：计划完成=2026-09-17", "2026-09-18 修改 T-005：计划完成=2026-09-21", "2026-09-18 相册「现场数据展示」加入图片（1 张）", "2026-09-18 相册「现场数据展示」加入图片（2 张）", "2026-09-18 相册「典型资源素材」加入图片（1 张）", "2026-09-18 相册「现场数据展示」图片 G-0001 恢复未命名", "2026-09-18 相册「现场数据展示」图片 G-0001 改名「看板」", "2026-09-18 相册「现场数据展示」图片 G-0001 恢复未命名", "2026-09-18 相册「现场数据展示」图片 G-0001 改名「看板示例」", "2026-09-19 导出待办明细 Excel（全部分类，32 条）", "2026-09-19 导出待办明细 Excel（全部分类，32 条）", "2026-09-19 状态改为「阻塞」 T-006", "2026-09-19 状态改为「待确认」 T-006", "2026-09-19 T-028 团队经费：工服以及零食 计划完成日期清空（拖入待分配池）", "2026-09-19 T-028 团队经费：工服以及零食 计划完成 （无） → 2026-09-24（日历拖拽）", "2026-09-19 修改工作台设置（名称「李锴的个人工作台」，隐藏模块：rooms）", "2026-09-19 新增分类「个人」", "2026-09-19 新增分类「项目」", "2026-09-19 修改工作台设置（名称「李锴的个人工作台」，隐藏模块：rooms）", "2026-09-19 修改工作台设置（名称「李锴的个人工作台」，隐藏模块：rooms）", "2026-09-19 修改工作台设置（名称「李锴的个人工作台」，隐藏模块：无）", "2026-09-19 修改工作台设置（名称「李锴的个人工作台」，隐藏模块：无）", "2026-09-19 修改工作台设置（名称「李锴的个人工作台」，隐藏模块：无）", "2026-09-20 手动调整卡片顺序", "2026-09-20 经小艺（微信）新增 T-033：车销每月分销处收货信息总表：销项空白排查与行查询明细完善", "2026-09-20 经小艺（微信）新增 T-034：空数据库：应付发票明细里付款日期为 NULL，这个小地方可能要改一下（周振提）", "2026-09-20 经小艺（微信）新增 T-035：机器作业记录：新增界面双下拉易误导，作业类型选择需优化（韦潇英提）", "2026-09-20 新建相册 A-009「视频素材库」" ], "dirty": 166, "baseAt": "2026-09-18 10:10", "cats": [ "公共", "部门", "二开", "空数据库", "个人", "项目" ], "memos": [ { "id": "M-001", "html": "\"图片\"", "created": "2026-09-18", "updated": "2026-09-18", "title": "二开场景" } ], "trash": [], "ord": { "T-032": 1, "T-003": 2, "T-027": 3, "T-004": 4, "T-009": 5, "T-005": 6, "T-006": 7, "T-010": 8, "T-008": 9, "T-026": 10, "T-028": 11, "T-007": 12, "T-014": 13, "T-015": 14, "T-020": 15, "T-029": 16, "T-016": 17, "T-017": 18, "T-018": 19, "T-019": 20, "T-030": 21, "T-031": 22, "T-002": 23, "T-011": 24, "T-012": 25, "T-013": 26, "T-021": 27, "T-022": 28, "T-023": 29, "T-024": 30, "T-025": 31, "T-001": 32 }, "sortMode": "manual", "rooms": [ { "id": "R-01", "code": "1502", "name": "1502", "std": 7, "max": 10, "img": "" }, { "id": "R-02", "code": "1511", "name": "1511", "std": 7, "max": 9, "img": "" }, { "id": "R-03", "code": "1512", "name": "1512", "std": 10, "max": 10, "img": "" }, { "id": "R-04", "code": "1513", "name": "1513", "std": 8, "max": 11, "img": "" }, { "id": "R-05", "code": "1514", "name": "1514", "std": 7, "max": 9, "img": "" }, { "id": "R-06", "code": "1515", "name": "1515", "std": 4, "max": 5, "img": "" }, { "id": "R-07", "code": "1516", "name": "1516", "std": 5, "max": 6, "img": "" }, { "id": "R-08", "code": "1517", "name": "1517", "std": 5, "max": 6, "img": "" }, { "id": "R-09", "code": "1518", "name": "1518", "std": 6, "max": 7, "img": "" }, { "id": "R-10", "code": "1611", "name": "1611", "std": 7, "max": 10, "img": "" }, { "id": "R-11", "code": "1612", "name": "1612", "std": 8, "max": 10, "img": "" }, { "id": "R-12", "code": "1613", "name": "1613", "std": 7, "max": 10, "img": "" }, { "id": "R-13", "code": "1614", "name": "1614", "std": 5, "max": 8, "img": "" }, { "id": "R-14", "code": "1801", "name": "1801", "std": 10, "max": 12, "img": "" }, { "id": "R-15", "code": "1802", "name": "1802", "std": 13, "max": 14, "img": "" }, { "id": "R-16", "code": "1803", "name": "1803", "std": 8, "max": 10, "img": "" }, { "id": "R-17", "code": "1807", "name": "1807", "std": 6, "max": 8, "img": "" }, { "id": "R-18", "code": "1712", "name": "1712", "std": 12, "max": 14, "img": "" }, { "id": "R-19", "code": "1713", "name": "1713", "std": 8, "max": 10, "img": "" } ], "allocs": [ { "id": "A-01", "roomId": "R-15", "project": "浙江罗克光电科技有限公司", "manager": "谌嘉俊", "area": "杭州", "dinner": 9, "date": "2026-09-17" }, { "id": "A-02", "roomId": "R-11", "project": "泰州市友动力科技有限…", "manager": "房鑫", "area": "上海", "dinner": 5, "date": "2026-09-17" }, { "id": "A-03", "roomId": "R-12", "project": "泰兴市领航电连接器有限…", "manager": "周彦", "area": "苏州", "dinner": 5, "date": "2026-09-17" }, { "id": "A-04", "roomId": "R-16", "project": "苏州金世博精密机电有限…", "manager": "丰冰", "area": "苏州", "dinner": 1, "date": "2026-09-17" }, { "id": "A-05", "roomId": "R-10", "project": "浙江欣杨智控科技有限公司", "manager": "陈辉", "area": "上海", "dinner": 10, "date": "2026-09-17" }, { "id": "A-06", "roomId": "R-14", "project": "成都嘉邦密封件股份有限…", "manager": "郭海飞", "area": "南京", "dinner": 5, "date": "2026-09-17" }, { "id": "A-07", "roomId": "R-17", "project": "上海东岩机械股份有限公司", "manager": "方江", "area": "上海", "dinner": 1, "date": "2026-09-17" }, { "id": "A-08", "roomId": "R-13", "project": "苏州凯聪智能科技有限公司", "manager": "陈志刚", "area": "苏州", "dinner": 4, "date": "2026-09-17" } ], "links": [ { "id": "L-01", "cat": "内部账套", "name": "管理员资源", "url": "https://b9.aio7.com/Push_VM229Client/?CorpID=ZY&IsLeader=Y#login" }, { "id": "L-02", "cat": "内部账套", "name": "空数据库", "url": "http://10.0.36.91/AIO8/AIO8Client/?CorpID=ERP&SOrgID=ERP&IsLeader=Y#index" }, { "id": "L-03", "cat": "内部账套", "name": "空数据库测试", "url": "http://10.0.36.91/T2/T2Client/index.html?CorpID=ERP&SOrgID=ERP#index" }, { "id": "L-04", "cat": "内部账套", "name": "MESTrain", "url": "https://zz_pscp_mestrain.aio8.pushiyun.com/AIO8Client/?CorpID=ERP#login/returnurl/index" }, { "id": "L-05", "cat": "内部账套", "name": "MESCloud", "url": "http://zzpbcloud.a.aio8cloud.com/AIO8MES/AIO8MESClient/index.html?CorpID=ERP&SOrgID=PUSH#index" }, { "id": "L-06", "cat": "内部账套", "name": "EKCloud", "url": "http://zzpbcloud.a.aio8cloud.com/AIO8EK/AIO8EKClient/index.html?CorpID=ERP#login/returnurl/index" }, { "id": "L-07", "cat": "内部账套", "name": "岗前新人培训", "url": "http://10.0.0.191:8045/AIO8Client/?CorpID=ERP&SOrgID=10#index" }, { "id": "L-08", "cat": "个人网址", "name": "公司网址", "url": "https://pushsoft.aio7.com/AIO8Client/?Corpid=Pushi&isleader#login/returnurl/index" }, { "id": "L-09", "cat": "个人网址", "name": "AIO8安装", "url": "https://dl.pushsoft.cn/aio8.html" }, { "id": "L-10", "cat": "个人网址", "name": "PDF转换", "url": "https://www.ilovepdf.com/zh-cn" }, { "id": "L-11", "cat": "个人网址", "name": "矢量图库", "url": "https://www.iconfont.cn/" }, { "id": "L-12", "cat": "个人网址", "name": "视觉素材", "url": "https://www.vcg.com/" } ], "snips": [ { "id": "S-01", "title": "进程查询，杀进程", "db": "MySQL", "tags": "", "sql": "SELECT\n s.session_id,\n s.status,\n s.login_name,\n s.host_name,\n s.program_name,\n s.open_transaction_count\nFROM sys.dm_exec_sessions s\nWHERE s.open_transaction_count > 0;\nkill session_id", "note": "", "created": "2026-09-18", "updated": "2026-09-18", "copies": 0 }, { "id": "S-02", "title": "批量删除工序，更新行号（用料对应行号未处理）", "db": "MSSQL", "tags": "", "sql": "SELECT T1.*,T2.DocEntry--,T3.LineNum,T3.PrcID\n--delete t3\nfrom [HDYLQX].[dbo].[2112211401_ItmID] T1\nLEFT JOIN MDBom T2 ON T1.ITMID=T2.ItmID\nLEFT JOIN MDBomB T3 ON T3.DocEntry=T2.DocEntry\nWHERE T3.PrcID='P007'\n\n\nselect S.*,S1.PrcID,S1.LineNum,S1.PreLineNum,S1.DocEntry\n--UPDATE S1 SET S1.LineNum=S.LineNum,S1.PreLineNum=S.PreLineNum\nFROM\n(\n\nSELECT ROW_NUMBER() OVER(PARTITION BY T3.DocEntry ORDER BY T3.LineNum)*10 LineNum,\n(ROW_NUMBER() OVER(PARTITION BY T3.DocEntry ORDER BY T3.LineNum)-1)*10 PreLineNum,T3.docEntry,t3.PrcID\nfrom [HDYLQX].[dbo].[2112211401_ItmID] T1\nLEFT JOIN MDBom T2 ON T1.ITMID=T2.ItmID\nLEFT JOIN MDBomB T3 ON T3.DocEntry=T2.DocEntry\n)S\nLEFT JOIN MDBOMB S1 ON S1.DOCENTRY=S.DOCENTRY AND S1.PrcID=S.PrcID\nwhere s.LineNum<>s1.LineNum or s.PreLineNum<>s1.PreLineNum", "note": "", "created": "2026-09-18", "updated": "2026-09-18", "copies": 0 }, { "id": "S-03", "title": "查询SQL工具历史", "db": "MySQL", "tags": "", "sql": "Select * From AALogSql Order By LogID desc", "note": "", "created": "2026-09-18", "updated": "2026-09-18", "copies": 0 }, { "id": "S-04", "title": "常用的批量更新语句", "db": "MySQL", "tags": "", "sql": "-- 更新现有数据，执行语句后需重启AIO8服务\n-- 查询\nUPDATE BQViw SET ExecOnPageLoad = 'N',ExecOnFilterChange = 'N' \n\n-- HOME列表\nUPDATE NTGrd SET ExecOnPageLoad = 'N',ExecOnFilterChange = 'N'\n-- 自定义业务HOME列表\nUPDATE DGGrd SET ExecOnPageLoad = 'N',ExecOnFilterChange = 'N'\n\n-- 需要去Group执行\n-- 更新个人设置：偏好设置\nUPDATE AGUsrSe SET DocHeaderPin = 'E',QueryHeaderPin = 'E',AutoShowApprove='N',AutoShowApproveM='N',ShowApprovePass='Y',NextAfApprove='Y',DisplayAfApprove='Y'\n\n\n\n-- 数据字典默认值，执行语句后需重启AIO8服务\n-- 设置查询默认值\nUPDATE AATblFd SET DefValue = 'N'\nWHERE TableID = 'BQViw' AND FieldName = 'ExecOnPageLoad' \nUPDATE AATblFd SET DefValue = 'N'\nWHERE TableID = 'BQViw' AND FieldName = 'ExecOnFilterChange' \n\n-- 设置HOME默认值\nUPDATE AATblFd SET DefValue = 'N'\nWHERE TableID = 'NTGrd' AND FieldName = 'ExecOnPageLoad' \nUPDATE AATblFd SET DefValue = 'N'\nWHERE TableID = 'NTGrd' AND FieldName = 'ExecOnFilterChange' \n\n-- 设置自定义业务：HOME默认值\nUPDATE AATblFd SET DefValue = 'N'\nWHERE TableID = 'DGGrd' AND FieldName = 'ExecOnPageLoad' \nUPDATE AATblFd SET DefValue = 'N'\nWHERE TableID = 'DGGrd' AND FieldName = 'ExecOnFilterChange' \n\n-- 设置个人设置：偏好设置，默认值\n-- 需要去Group执行\nUPDATE AATblFd SET DefValue = 'E'\nWHERE TableID = 'AGUsrSe' AND FieldName = 'DocHeaderPin' \n\nUPDATE AATblFd SET DefValue = 'E'\nWHERE TableID = 'AGUsrSe' AND FieldName = 'QueryHeaderPin' \n\nUPDATE AATblFd SET DefValue = 'N'\nWHERE TableID = 'AGUsrSe' AND FieldName = 'AutoShowApprove';\n\nUPDATE AATblFd SET DefValue = 'N'\nWHERE TableID = 'AGUsrSe' AND FieldName = 'AutoShowApproveM';\n\nUPDATE AATblFd SET DefValue = 'Y'\nWHERE TableID = 'AGUsrSe' AND FieldName = 'ShowApprovePass';\n\nUPDATE AATblFd SET DefValue = 'Y'\nWHERE TableID = 'AGUsrSe' AND FieldName = 'NextAfApprove';\n\nUPDATE AATblFd SET DefValue = 'Y'\nWHERE TableID = 'AGUsrSe' AND FieldName = 'DisplayAfApprove';\n\n-- 批量启用HOME的EDI导入\n-- MYSQL:\nUPDATE NTGrd SET ToolFunList = (CASE WHEN ToolFunList LIKE '%EdiImport%' THEN ToolFunList \n WHEN IFNULL(ToolFunList,'') = '' THEN 'EdiImport' \n ELSE CONCAT(ToolFunList , ',EdiImport') END)\n\n-- MSSQL：\nUPDATE NTGrd SET ToolFunList = (CASE WHEN ToolFunList LIKE '%EdiImport%' THEN ToolFunList \n WHEN ISNULL(ToolFunList,'') = '' THEN 'EdiImport' \n ELSE ToolFunList + ',EdiImport' END)\n", "note": "", "created": "2026-09-18", "updated": "2026-09-18", "copies": 0 }, { "id": "S-05", "title": "75查询EDI清单", "db": "MySQL", "tags": "", "sql": "SELECT TM.ViewID,TM.Viewname,TM.EdiID\nfrom QRViw TM\nwhere TM.EdiID is not NULL", "note": "", "created": "2026-09-18", "updated": "2026-09-18", "copies": 0 }, { "id": "S-06", "title": "南通汇统维度调整调批次结账表", "db": "MySQL", "tags": "", "sql": "WITH WDTZ as \n(select TD.BatCHNum,TD.ItmID,TD.WhsID,TD.QtyDirect,SUM(TD.Qty) Qty\nfrom BCAdjA TD \nwhere TD.AbsID=202512\ngroup by TD.BatCHNum,TD.ItmID,TD.WhsID,TD.QtyDirect)\n\n-- select TB.ItmID,TB.BatchNum,TB.WhsID,TB.BeginQty,TB.InQty,TB.OutQty,TB.EndQty,TB.InQTy-IFNULL(TD1.Qty,0) InQty1,TB.OutQty+IFNULL(TD2.Qty,0) OutQty1\n-- \t\t,TB.BeginQty+TB.InQTy-IFNULL(TD1.Qty,0)-(TB.OutQty+IFNULL(TD2.Qty,0)) EndQty1\n-- from\nupdate AAFinBt TB \nleft join WDTZ TD1 on TD1.ItmID=TB.ItmID and TD1.BatchNum=TB.BatchNum and TD1.WhsID=TB.WhsID and TD1.QtyDirect='A'\nleft join WDTZ TD2 on TD2.ItmID=TB.ItmID and TD2.BatchNum=TB.BatchNum and TD2.WhsID=TB.WhsID and TD2.QtyDirect='B'\nset TB.InQty=TB.InQTy-IFNULL(TD1.Qty,0) ,TB.OutQty=TB.OutQty+IFNULL(TD2.Qty,0),TB.EndQty=TB.BeginQty+TB.InQTy-IFNULL(TD1.Qty,0)-(TB.OutQty+IFNULL(TD2.Qty,0)) \nwhere TB.AbsID=202512", "note": "", "created": "2026-09-18", "updated": "2026-09-18", "copies": 0 }, { "id": "S-07", "title": "检查单一批次", "db": "MySQL", "tags": "", "sql": "select TB.ItmID,'PURevA' from PURevA TB where TB.AbsID in ('202511') and IFNULL(TB.BatchNum, '') = ''\nUnion All\nselect TB.ItmID,'PUBakA' from PUBakA TB where TB.AbsID in ('202511') and IFNULL(TB.BatchNum, '') = ''\nUnion All\nselect TB.ItmID,'SASalA' from SASalA TB where TB.AbsID in ('202511') and IFNULL(TB.BatchNum, '') = ''\nUnion All\nselect TB.ItmID,'SABakA' from SABakA TB where TB.AbsID in ('202511') and IFNULL(TB.BatchNum, '') = ''\nUnion All\nselect TB.ItmID,'WHPinA' from WHPinA TB where TB.AbsID in ('202511') and IFNULL(TB.BatchNum, '') = ''\nUnion All\nselect TB.ItmID,'WHPouA' from WHPouA TB where TB.AbsID in ('202511') and IFNULL(TB.BatchNum, '') = ''\nUnion All\nselect TB.ItmID,'WHDrwA' from WHDrwA TB where TB.AbsID in ('202511') and IFNULL(TB.BatchNum, '') = ''\nUnion All\nselect TB.ItmID,'WHBakA' from WHBakA TB where TB.AbsID in ('202511') and IFNULL(TB.BatchNum, '') = ''\nUnion All\nselect TB.ItmID,'WHWinA' from WHWinA TB where TB.AbsID in ('202511') and IFNULL(TB.BatchNum, '') = ''\nUnion All\nselect TB.ItmID,'WHWouA' from WHWouA TB where TB.AbsID in ('202511') and IFNULL(TB.BatchNum, '') = ''\nUnion All\nselect TB.ItmID,'WHOinA' from WHOinA TB where TB.AbsID in ('202511') and IFNULL(TB.BatchNum, '') = ''\nUnion All\nselect TB.ItmID,'WHOouA' from WHOouA TB where TB.AbsID in ('202511') and IFNULL(TB.BatchNum, '') = ''\nUnion All\nselect TB.ItmID,'WHScpA' from WHScpA TB where TB.AbsID in ('202511') and IFNULL(TB.BatchNum, '') = ''\nUnion All\nselect TB.ItmID,'WHChkA' from WHChkA TB where TB.AbsID in ('202511') and IFNULL(TB.BatchNum, '') = ''\nUnion All\nselect TB.ItmID,'WHSinA' from WHSinA TB where TB.AbsID in ('202511') and IFNULL(TB.BatchNum, '') = ''\nUnion All\nselect TB.ItmID,'WHSouA' from WHSouA TB where TB.AbsID in ('202511') and IFNULL(TB.BatchNum, '') = ''\nUnion All\nselect TB.ItmID,'WHAltA' from WHAltA TB where TB.AbsID in ('202511') and IFNULL(TB.BatchNum, '') = ''\nUnion All\nselect TB.ItmID,'WHBrwA' from WHBrwA TB where TB.AbsID in ('202511') and IFNULL(TB.BatchNum, '') = ''\nUnion All\nselect TB.ItmID,'WHRetA' from WHRetA TB where TB.AbsID in ('202511') and IFNULL(TB.BatchNum, '') = ''\n\nUnion All\nselect TB.ItmID,'COAdjA' from COAdjA TB where TB.AbsID in ('202511') and IFNULL(TB.BatchNum, '') = ''\nUnion All\nselect TB.ItmID,'COPadA' from COPadA TB where TB.AbsID in ('202511') and IFNULL(TB.BatchNum, '') = ''\nUnion All\nselect TB.ItmID,'COCadA' from COCadA TB where TB.AbsID in ('202511') and IFNULL(TB.BatchNum, '') = ''\n\t\n", "note": "", "created": "2026-09-18", "updated": "2026-09-18", "copies": 0 }, { "id": "S-08", "title": "75升8更新组织ID", "db": "MySQL", "tags": "", "sql": "UPDATE AADatD TD SET TD.SOrgID = 'ERP';\nUPDATE AADrf TD SET TD.SOrgID = 'ERP';\nUPDATE AARel TD SET TD.SOrgID = 'ERP';\nUPDATE AASsn TD SET TD.SOrgID = 'ERP';\nUPDATE BCAdj TD SET TD.SOrgID = 'ERP';\nUPDATE BCIbr TD SET TD.SOrgID = 'ERP';\nUPDATE BCOpn TD SET TD.SOrgID = 'ERP';\nUPDATE BPClt TD SET TD.LnkSOrgID = 'ERP';\nUPDATE BPVnd TD SET TD.LnkSOrgID = 'ERP';\nUPDATE CBAlt TD SET TD.SOrgID = 'ERP';\nUPDATE CBBgn TD SET TD.SOrgID = 'ERP';\nUPDATE CBBpy TD SET TD.SOrgID = 'ERP';\nUPDATE CBBrc TD SET TD.SOrgID = 'ERP';\nUPDATE CBBrw TD SET TD.SOrgID = 'ERP';\nUPDATE CBCbp TD SET TD.SOrgID = 'ERP';\nUPDATE CBCbr TD SET TD.SOrgID = 'ERP';\nUPDATE CBCep TD SET TD.SOrgID = 'ERP';\nUPDATE CBCin TD SET TD.SOrgID = 'ERP';\nUPDATE CBCou TD SET TD.SOrgID = 'ERP';\nUPDATE CBExp TD SET TD.SOrgID = 'ERP';\nUPDATE CBInc TD SET TD.SOrgID = 'ERP';\nUPDATE CBJep TD SET TD.SOrgID = 'ERP';\nUPDATE CBLbl TD SET TD.SOrgID = 'ERP';\nUPDATE CBLbp TD SET TD.SOrgID = 'ERP';\nUPDATE CBLpy TD SET TD.SOrgID = 'ERP';\nUPDATE CBLrc TD SET TD.SOrgID = 'ERP';\nUPDATE CBObw TD SET TD.SOrgID = 'ERP';\nUPDATE CBOrt TD SET TD.SOrgID = 'ERP';\nUPDATE CBRtn TD SET TD.SOrgID = 'ERP';\nUPDATE COAdj TD SET TD.SOrgID = 'ERP';\nUPDATE COAlt TD SET TD.SOrgID = 'ERP';\nUPDATE COCad TD SET TD.SOrgID = 'ERP';\nUPDATE COExc TD SET TD.SOrgID = 'ERP';\nUPDATE COExd TD SET TD.SOrgID = 'ERP';\nUPDATE COMad TD SET TD.SOrgID = 'ERP';\nUPDATE COMip TD SET TD.SOrgID = 'ERP';\nUPDATE COPad TD SET TD.SOrgID = 'ERP';\nUPDATE COPip TD SET TD.SOrgID = 'ERP';\nUPDATE COWip TD SET TD.SOrgID = 'ERP';\nUPDATE CPIqc TD SET TD.SOrgID = 'ERP';\nUPDATE EMCal TD SET TD.SOrgID = 'ERP';\nUPDATE EMCmt TD SET TD.SOrgID = 'ERP';\nUPDATE EMDsp TD SET TD.SOrgID = 'ERP';\nUPDATE EMExc TD SET TD.SOrgID = 'ERP';\nUPDATE EMLaj TD SET TD.SOrgID = 'ERP';\nUPDATE EMMcb TD SET TD.SOrgID = 'ERP';\nUPDATE EMMcp TD SET TD.SOrgID = 'ERP';\nUPDATE EMMcw TD SET TD.SOrgID = 'ERP';\nUPDATE EMMdp TD SET TD.SOrgID = 'ERP';\nUPDATE EMMdr TD SET TD.SOrgID = 'ERP';\nUPDATE EMMdw TD SET TD.SOrgID = 'ERP';\nUPDATE EMMin TD SET TD.SOrgID = 'ERP';\nUPDATE EMMou TD SET TD.SOrgID = 'ERP';\nUPDATE EMMup TD SET TD.SOrgID = 'ERP';\nUPDATE EMRep TD SET TD.SOrgID = 'ERP';\nUPDATE EMRepMd TD SET TD.SOrgID = 'ERP';\nUPDATE EMScp TD SET TD.SOrgID = 'ERP';\nUPDATE EMSpa TD SET TD.SOrgID = 'ERP';\nUPDATE EMStu TD SET TD.SOrgID = 'ERP';\nUPDATE EMUsf TD SET TD.SOrgID = 'ERP';\nUPDATE ESApm TD SET TD.SOrgID = 'ERP';\nUPDATE ESAps TD SET TD.SOrgID = 'ERP';\nUPDATE ESDayM TD SET TD.SOrgID = 'ERP';\nUPDATE ESDayT TD SET TD.SOrgID = 'ERP';\nUPDATE ESDot TD SET TD.SOrgID = 'ERP';\nUPDATE ESDou TD SET TD.SOrgID = 'ERP';\nUPDATE ESFed TD SET TD.SOrgID = 'ERP';\nUPDATE ESJob TD SET TD.SOrgID = 'ERP';\nUPDATE ESMcc TD SET TD.SOrgID = 'ERP';\nUPDATE ESPer TD SET TD.SOrgID = 'ERP';\nUPDATE ESPin TD SET TD.SOrgID = 'ERP';\nUPDATE ESPln TD SET TD.SOrgID = 'ERP';\nUPDATE ESPou TD SET TD.SOrgID = 'ERP';\nUPDATE ESPqc TD SET TD.SOrgID = 'ERP';\nUPDATE ESPrd TD SET TD.SOrgID = 'ERP';\nUPDATE ESRde TD SET TD.SOrgID = 'ERP';\nUPDATE ESRhr TD SET TD.SOrgID = 'ERP';\nUPDATE ESRms TD SET TD.SOrgID = 'ERP';\nUPDATE ESRpt TD SET TD.SOrgID = 'ERP';\nUPDATE ESTay TD SET TD.SOrgID = 'ERP';\nUPDATE ESTsf TD SET TD.SOrgID = 'ERP';\nUPDATE ESTsp TD SET TD.SOrgID = 'ERP';\nUPDATE ESUpt TD SET TD.SOrgID = 'ERP';\nUPDATE ESVbk TD SET TD.SOrgID = 'ERP';\nUPDATE ESVdw TD SET TD.SOrgID = 'ERP';\nUPDATE ESVrp TD SET TD.SOrgID = 'ERP';\nUPDATE ESWtg TD SET TD.SOrgID = 'ERP';\nUPDATE ESWtk TD SET TD.SOrgID = 'ERP';\nUPDATE FBAdj TD SET TD.SOrgID = 'ERP';\nUPDATE FBAdjA TD SET TD.SOrgID = 'ERP';\nUPDATE FBSchA TD SET TD.SOrgID = 'ERP';\nUPDATE FBSchD TD SET TD.SOrgID = 'ERP';\nUPDATE FBSchF TD SET TD.SOrgID = 'ERP';\nUPDATE FXAdj TD SET TD.SOrgID = 'ERP';\nUPDATE FXAst TD SET TD.SOrgID = 'ERP';\nUPDATE FXAstA TD SET TD.SOrgID = 'ERP';\nUPDATE FXAstZ TD SET TD.SOrgID = 'ERP';\nUPDATE FXBal TD SET TD.SOrgID = 'ERP';\nUPDATE FXBalS TD SET TD.SOrgID = 'ERP';\nUPDATE FXDis TD SET TD.SOrgID = 'ERP';\nUPDATE FXDpj TD SET TD.SOrgID = 'ERP';\nUPDATE FXDpr TD SET TD.SOrgID = 'ERP';\nUPDATE FXDps TD SET TD.SOrgID = 'ERP';\nUPDATE GLBrq TD SET TD.SOrgID = 'ERP';\nUPDATE LODbak TD SET TD.SOrgID = 'ERP';\nUPDATE LODrw TD SET TD.SOrgID = 'ERP';\nUPDATE LOObak TD SET TD.SOrgID = 'ERP';\nUPDATE LOOin TD SET TD.SOrgID = 'ERP';\nUPDATE LOReq TD SET TD.SOrgID = 'ERP';\nUPDATE MDBlm TD SET TD.SOrgID = 'ERP';\nUPDATE MDEcn TD SET TD.SOrgID = 'ERP';\nUPDATE MDWhs TD SET TD.SOrgID = 'ERP';\nUPDATE MMMut TD SET TD.SOrgID = 'ERP';\nUPDATE MMOrd TD SET TD.SOrgID = 'ERP';\nUPDATE MMPin TD SET TD.SOrgID = 'ERP';\nUPDATE MMPou TD SET TD.SOrgID = 'ERP';\nUPDATE MMPsc TD SET TD.SOrgID = 'ERP';\nUPDATE MMRde TD SET TD.SOrgID = 'ERP';\nUPDATE MMRhr TD SET TD.SOrgID = 'ERP';\nUPDATE MMRms TD SET TD.SOrgID = 'ERP';\nUPDATE MMUpt TD SET TD.SOrgID = 'ERP';\nUPDATE MMWut TD SET TD.SOrgID = 'ERP';\nUPDATE MNBak TD SET TD.SOrgID = 'ERP';\nUPDATE MNBtm TD SET TD.SOrgID = 'ERP';\nUPDATE MNCmp TD SET TD.SOrgID = 'ERP';\nUPDATE MNDrw TD SET TD.SOrgID = 'ERP';\nUPDATE MNOrd TD SET TD.SOrgID = 'ERP';\nUPDATE MNPdw TD SET TD.SOrgID = 'ERP';\nUPDATE MNPnd TD SET TD.SOrgID = 'ERP';\nUPDATE MNPnm TD SET TD.SOrgID = 'ERP';\nUPDATE MNPnq TD SET TD.SOrgID = 'ERP';\nUPDATE MNPrd TD SET TD.SOrgID = 'ERP';\nUPDATE MNPrm TD SET TD.SOrgID = 'ERP';\nUPDATE MNPrq TD SET TD.SOrgID = 'ERP';\nUPDATE MNRec TD SET TD.SOrgID = 'ERP';\nUPDATE MNRev TD SET TD.SOrgID = 'ERP';\nUPDATE MNTbk TD SET TD.SOrgID = 'ERP';\nUPDATE MNTmp TD SET TD.SOrgID = 'ERP';\nUPDATE MNUpt TD SET TD.SOrgID = 'ERP';\nUPDATE MRAtp TD SET TD.SOrgID = 'ERP';\nUPDATE MRBcm TD SET TD.SOrgID = 'ERP';\nUPDATE MRBrp TD SET TD.SOrgID = 'ERP';\nUPDATE MRCmp TD SET TD.SOrgID = 'ERP';\nUPDATE MRLay TD SET TD.SOrgID = 'ERP';\nUPDATE MRMrp TD SET TD.SOrgID = 'ERP';\nUPDATE MRPln TD SET TD.SOrgID = 'ERP';\nUPDATE MRSrp TD SET TD.SOrgID = 'ERP';\nUPDATE PRCav TD SET TD.SOrgID = 'ERP';\nUPDATE PRDrb TD SET TD.SOrgID = 'ERP';\nUPDATE PRDrc TD SET TD.SOrgID = 'ERP';\nUPDATE PREpa TD SET TD.SOrgID = 'ERP';\nUPDATE PREpn TD SET TD.SOrgID = 'ERP';\nUPDATE PRExc TD SET TD.SOrgID = 'ERP';\nUPDATE PRPay TD SET TD.SOrgID = 'ERP';\nUPDATE PRPck TD SET TD.SOrgID = 'ERP';\nUPDATE PRPic TD SET TD.SOrgID = 'ERP';\nUPDATE PRPin TD SET TD.SOrgID = 'ERP';\nUPDATE PRPoi TD SET TD.SOrgID = 'ERP';\nUPDATE PRPpl TD SET TD.SOrgID = 'ERP';\nUPDATE PRPrb TD SET TD.SOrgID = 'ERP';\nUPDATE PRPrp TD SET TD.SOrgID = 'ERP';\nUPDATE PRPtm TD SET TD.SOrgID = 'ERP';\nUPDATE PRPyy TD SET TD.SOrgID = 'ERP';\nUPDATE PRRec TD SET TD.SOrgID = 'ERP';\nUPDATE PRReq TD SET TD.SOrgID = 'ERP';\nUPDATE PRSic TD SET TD.SOrgID = 'ERP';\nUPDATE PRSin TD SET TD.SOrgID = 'ERP';\nUPDATE PRSoi TD SET TD.SOrgID = 'ERP';\nUPDATE PRSpl TD SET TD.SOrgID = 'ERP';\nUPDATE PRStm TD SET TD.SOrgID = 'ERP';\nUPDATE PUAdj TD SET TD.SOrgID = 'ERP';\nUPDATE PUBak TD SET TD.SOrgID = 'ERP';\nUPDATE PUBtm TD SET TD.SOrgID = 'ERP';\nUPDATE PUInv TD SET TD.SOrgID = 'ERP';\nUPDATE PUOrd TD SET TD.SOrgID = 'ERP';\nUPDATE PUPsd TD SET TD.SOrgID = 'ERP';\nUPDATE PUPsm TD SET TD.SOrgID = 'ERP';\nUPDATE PUPsq TD SET TD.SOrgID = 'ERP';\nUPDATE PURec TD SET TD.SOrgID = 'ERP';\nUPDATE PUReq TD SET TD.SOrgID = 'ERP';\nUPDATE PURev TD SET TD.SOrgID = 'ERP';\nUPDATE PURfq TD SET TD.SOrgID = 'ERP';\nUPDATE PURfr TD SET TD.SOrgID = 'ERP';\nUPDATE PURtm TD SET TD.SOrgID = 'ERP';\nUPDATE PUTbk TD SET TD.SOrgID = 'ERP';\nUPDATE PUTmp TD SET TD.SOrgID = 'ERP';\nUPDATE PUUpt TD SET TD.SOrgID = 'ERP';\nUPDATE QMAbn TD SET TD.SOrgID = 'ERP';\nUPDATE QMPln TD SET TD.SOrgID = 'ERP';\nUPDATE RFAdj TD SET TD.SOrgID = 'ERP';\nUPDATE RFMio TD SET TD.SOrgID = 'ERP';\nUPDATE SAAdj TD SET TD.SOrgID = 'ERP';\nUPDATE SABak TD SET TD.SOrgID = 'ERP';\nUPDATE SABtm TD SET TD.SOrgID = 'ERP';\nUPDATE SAInv TD SET TD.SOrgID = 'ERP';\nUPDATE SAOrd TD SET TD.SOrgID = 'ERP';\nUPDATE SAPln TD SET TD.SOrgID = 'ERP';\nUPDATE SAPsd TD SET TD.SOrgID = 'ERP';\nUPDATE SAPsm TD SET TD.SOrgID = 'ERP';\nUPDATE SAPsq TD SET TD.SOrgID = 'ERP';\nUPDATE SAQut TD SET TD.SOrgID = 'ERP';\nUPDATE SARec TD SET TD.SOrgID = 'ERP';\nUPDATE SASal TD SET TD.SOrgID = 'ERP';\nUPDATE SASgn TD SET TD.SOrgID = 'ERP';\nUPDATE SATbk TD SET TD.SOrgID = 'ERP';\nUPDATE SATmp TD SET TD.SOrgID = 'ERP';\nUPDATE SATpa TD SET TD.SOrgID = 'ERP';\nUPDATE SAUpt TD SET TD.SOrgID = 'ERP';\nUPDATE SCAdj TD SET TD.SOrgID = 'ERP';\nUPDATE SCExc TD SET TD.SOrgID = 'ERP';\nUPDATE SCExd TD SET TD.SOrgID = 'ERP';\nUPDATE SCHou TD SET TD.SOrgID = 'ERP';\nUPDATE SCMak TD SET TD.SOrgID = 'ERP';\nUPDATE SCNew TD SET TD.SOrgID = 'ERP';\nUPDATE SCPip TD SET TD.SOrgID = 'ERP';\nUPDATE UBDtm TD SET TD.SOrgID = 'ERP';\nUPDATE UBMrd TD SET TD.SOrgID = 'ERP';\nUPDATE UBOMrd TD SET TD.SOrgID = 'ERP';\nUPDATE UBOPrc TD SET TD.SOrgID = 'ERP';\nUPDATE UBPag TD SET TD.SOrgID = 'ERP';\nUPDATE UBPrc TD SET TD.SOrgID = 'ERP';\nUPDATE WHAlt TD SET TD.SOrgID = 'ERP';\nUPDATE WHAod TD SET TD.SOrgID = 'ERP';\nUPDATE WHBak TD SET TD.SOrgID = 'ERP';\nUPDATE WHBrw TD SET TD.SOrgID = 'ERP';\nUPDATE WHChk TD SET TD.SOrgID = 'ERP';\nUPDATE WHDbt TD SET TD.SOrgID = 'ERP';\nUPDATE WHDrw TD SET TD.SOrgID = 'ERP';\nUPDATE WHDtb TD SET TD.SOrgID = 'ERP';\nUPDATE WHDtm TD SET TD.SOrgID = 'ERP';\nUPDATE WHLin TD SET TD.SOrgID = 'ERP';\nUPDATE WHLio TD SET TD.SOrgID = 'ERP';\nUPDATE WHLou TD SET TD.SOrgID = 'ERP';\nUPDATE WHMio TD SET TD.SOrgID = 'ERP';\nUPDATE WHOid TD SET TD.SOrgID = 'ERP';\nUPDATE WHOin TD SET TD.SOrgID = 'ERP';\nUPDATE WHOod TD SET TD.SOrgID = 'ERP';\nUPDATE WHOot TD SET TD.SOrgID = 'ERP';\nUPDATE WHOou TD SET TD.SOrgID = 'ERP';\nUPDATE WHOrd TD SET TD.SOrgID = 'ERP';\nUPDATE WHOtm TD SET TD.SOrgID = 'ERP';\nUPDATE WHPbt TD SET TD.SOrgID = 'ERP';\nUPDATE WHPin TD SET TD.SOrgID = 'ERP';\nUPDATE WHPld TD SET TD.SOrgID = 'ERP';\nUPDATE WHPlm TD SET TD.SOrgID = 'ERP';\nUPDATE WHPlq TD SET TD.SOrgID = 'ERP';\nUPDATE WHPou TD SET TD.SOrgID = 'ERP';\nUPDATE WHPtb TD SET TD.SOrgID = 'ERP';\nUPDATE WHPtm TD SET TD.SOrgID = 'ERP';\nUPDATE WHRet TD SET TD.SOrgID = 'ERP';\nUPDATE WHScp TD SET TD.SOrgID = 'ERP';\nUPDATE WHSin TD SET TD.SOrgID = 'ERP';\nUPDATE WHSit TD SET TD.SOrgID = 'ERP';\nUPDATE WHSot TD SET TD.SOrgID = 'ERP';\nUPDATE WHSou TD SET TD.SOrgID = 'ERP';\nUPDATE WHTpi TD SET TD.SOrgID = 'ERP';\nUPDATE WHTpo TD SET TD.SOrgID = 'ERP';\nUPDATE WHWin TD SET TD.SOrgID = 'ERP';\nUPDATE WHWot TD SET TD.SOrgID = 'ERP';\nUPDATE WHWou TD SET TD.SOrgID = 'ERP';\nUPDATE WHWtm TD SET TD.SOrgID = 'ERP';", "note": "", "created": "2026-09-18", "updated": "2026-09-18", "copies": 0 }, { "id": "S-09", "title": "多组织总账变更核算属性", "db": "MySQL", "tags": "", "sql": "update aio8_group.FGVouA TD\nleft join BPVnd TB on TB.VndID='P40100'\nset TD.CrdID='P40100',TD.CrdName=TB.VndName\nwhere TD.CrdID='P40054';\n\nupdate aio8_group.FGFinFa TD\nleft join BPVnd TB on TB.VndID='P40100'\nset TD.CrdID='P40100',TD.CrdName=TB.VndName\nwhere TD.CrdID='P40054';\n\nupdate aio8_group.FGAccPd TD\nset TD.ISClose='Y'\nwhere TD.AccPropertyID='P40054';", "note": "", "created": "2026-09-18", "updated": "2026-09-18", "copies": 0 }, { "id": "S-10", "title": "y友邦根据生产号查领料", "db": "MySQL", "tags": "", "sql": "CREATE TEMPORARY TABLE TempA (\n\tNumAtCrd VARCHAR ( 100 ),\nQty NUMERIC ( 28, 9 ));\n\nINSERT INTO TempA ( NumAtCrd, Qty ) \nVALUES \n('25.02-128',1),\n('25.03-151',18),\n('25.03-139',1),\n('25.02-188',20),\n('25.02-212',6),\n('25.02-211',6),\n('25.02-213',6),\n('25.02-214',6),\n('25.02-215',6),\n('25.04-027',14),\n('25.03-062',6),\n('25.03-063',6),\n('25.04-207',28),\n('25.04-208',13),\n('25.03-127',40),\n('25.03-069',8),\n('25.05-000',1),\n('25.03-070',8),\n('25.03-128',40),\n('25.03-129',40),\n('25.03-153',32),\n('25.03-155',20),\n('25.05-038',8),\n('25.05-045',5),\n('25.05-037',7),\n('25.05-044',9),\n('25.05-030',24);\n\nselect TB.NumAtCrd,TB.Qty,TM.DocNum,TM.ItmID,TM.ItmName,TM.ItmSpec,TM.Qty,TM.OpenCreQty,TD.ItmID,TD.ItmName,TD.ItmSpec,TD.UomID,TD.Qty,TD.OpenCreQty,TD.Qty*TB.Qty/TM.Qty YL,TB3.OnHand\nfrom TempA TB \nleft join MMOrd TM on TM.Z_SCH=TB.NumAtCrd\nleft join MMOrdA TD on TD.DocEntry=TM.DocEntry\nleft join MDItm TB2 on TB2.ItmID=TM.ItmID\nleft join BCStk TB3 on TB3.ItmID=TD.ItmID and TB3.WhsID=TD.WhsID\nwhere TM.DocEntry is not null and TB2.ItmKindID='N001'\n\n;\n\nDROP TEMPORARY TABLE\nIF\n\tEXISTS TempA;\n\n", "note": "", "created": "2026-09-18", "updated": "2026-09-18", "copies": 0 }, { "id": "S-11", "title": "identity_insert 插入电键", "db": "MySQL", "tags": "", "sql": "set identity_insert 表名 ON\nset identity_insert 表名 OFF", "note": "", "created": "2026-09-18", "updated": "2026-09-18", "copies": 0 }, { "id": "S-12", "title": "云版数据库名查看", "db": "MySQL", "tags": "", "sql": "SHOW DATABASES;", "note": "", "created": "2026-09-18", "updated": "2026-09-18", "copies": 0 }, { "id": "S-13", "title": "重点SQL-工单后续凭证不在工单有效期(附解决办法)(1)", "db": "MySQL", "tags": "", "sql": "\n--单据日期在工单凭证日期之前\nselect TM.DocDate ,S1.MINDocDate ,TM.FinishedDate, S1.MAXDocDate\n--UPDATE TM SET TM.DocDate =S1.MINDocDate \nfrom MMOrd TM \nLEFT JOIN (\n\tSELECT S.BaseEntry ,MAX(S.MAXDocDate ) MAXDocDate,MIN(S.MINDocDate ) MINDocDate\n\tFROM (\n\t\t--领料\n\t\tSELECT TD.BaseEntry ,MAX(TM.DocDate ) MAXDocDate,MIN(TM.DocDate ) MINDocDate\n\t\tFROM WHDrw TM \n\t\tLEFT JOIN WHDrwA TD ON TM.DocEntry =TD.DocEntry \n\t\tGROUP BY TD.BaseEntry\n\t\tunion all \n\t\t--退料\n\t\tSELECT TD.BaseEntry ,MAX(TM.DocDate ) MAXDocDate,MIN(TM.DocDate ) MINDocDate\n\t\tFROM WHBak TM \n\t\tLEFT JOIN WHBakA TD ON TM.DocEntry =TD.DocEntry \n\t\tGROUP BY TD.BaseEntry\n\t\tunion all \n\t\t--入库\n\t\tSELECT TD.BaseEntry ,MAX(TM.DocDate ) MAXDocDate,MIN(TM.DocDate ) MINDocDate\n\t\tFROM WHPin TM \n\t\tLEFT JOIN WHPinA TD ON TM.DocEntry =TD.DocEntry \n\t\tGROUP BY TD.BaseEntry\n\t\tunion all \n\t\t--退制\n\t\tSELECT TD.BaseEntry ,MAX(TM.DocDate ) MAXDocDate,MIN(TM.DocDate ) MINDocDate\n\t\tFROM WHPou TM \n\t\tLEFT JOIN WHPouA TD ON TM.DocEntry =TD.DocEntry \n\t\tGROUP BY TD.BaseEntry\n\t\tunion all \n\t\t--外协入库\n\t\tSELECT TM3.BaseEntry ,MAX(TM2.DocDate ) MAXDocDate,MIN(TM2.DocDate ) MINDocDate\n\t\tFROM MNOrd TM \n\t\tLEFT JOIN MNOrdA TD ON TM.DocEntry =TD.DocEntry \n\t\tLEFT JOIN MNRevA TD2 ON TD2.BaseEntry =TD.DocEntry AND TD2.BaseType =TD.ObjType \n\t\tleft join MNRev TM2 ON TM2.DocEntry =TD2.DocEntry \n\t\tleft join ESPrd TM3 ON TM3.DocEntry =TD.BaseEntry \n\t\tGROUP BY TM3.BaseEntry\n\t\tunion all \n\t\t--外协退货\n\t\tSELECT TM3.BaseEntry ,MAX(TM2.DocDate ) MAXDocDate,MIN(TM2.DocDate ) MINDocDate\n\t\tFROM MNOrd TM \n\t\tLEFT JOIN MNOrdA TD ON TM.DocEntry =TD.DocEntry \n\t\tLEFT JOIN MNBakA TD2 ON TD2.BaseEntry =TD.DocEntry AND TD2.BaseType =TD.ObjType \n\t\tleft join MNBak TM2 ON TM2.DocEntry =TD2.DocEntry \n\t\tleft join ESPrd TM3 ON TM3.DocEntry =TD.BaseEntry \n\t\tGROUP BY TM3.BaseEntry\n\t\tunion all \n\t\t--外协赔偿\n\t\tSELECT TM3.BaseEntry ,MAX(TM2.DocDate ) MAXDocDate,MIN(TM2.DocDate ) MINDocDate\n\t\tFROM MNOrd TM \n\t\tLEFT JOIN MNOrdA TD ON TM.DocEntry =TD.DocEntry \n\t\tLEFT JOIN MNCmpA TD2 ON TD2.BaseEntry =TD.DocEntry AND TD2.BaseType =TD.ObjType \n\t\tleft join MNCmp TM2 ON TM2.DocEntry =TD2.DocEntry \n\t\tleft join ESPrd TM3 ON TM3.DocEntry =TD.BaseEntry \n\t\tGROUP BY TM3.BaseEntry\n\t\t--不考虑付品单据\n\t) S \n\tGROUP BY S.BaseEntry\n) S1 ON S1.BaseEntry=TM.DocEntry \nWHERE LEFT(CONVERT(varchar(12) , TM.DocDate, 112 ),6)>LEFT(CONVERT(varchar(12) , S1.MINDocDate, 112 ),6)\nAND S1.MINDocDate IS NOT NULL \n\n--更了凭证日期，更一遍账期\nselect TM.ABSID ,LEFT(CONVERT(varchar(12) , TM.DocDate, 112 ),6)\n--UPDATE TM SET TM.ABSID =LEFT(CONVERT(varchar(12) , TM.DocDate, 112 ),6)\nfrom MMOrd TM \nwhere TM.AbsID <>LEFT(CONVERT(varchar(12) , TM.DocDate, 112 ),6)\n\n--单据日期在工单完工日期之后\nselect TM.DocDate ,S1.MINDocDate ,TM.FinishedDate, S1.MAXDocDate,TM.DocEntry \n--UPDATE TM SET TM.FinishedDate =S1.MAXDocDate \nfrom MMOrd TM \nLEFT JOIN (\n\tSELECT S.BaseEntry ,MAX(S.MAXDocDate ) MAXDocDate,MIN(S.MINDocDate ) MINDocDate\n\tFROM (\n\t\t--领料\n\t\tSELECT TD.BaseEntry ,MAX(TM.DocDate ) MAXDocDate,MIN(TM.DocDate ) MINDocDate\n\t\tFROM WHDrw TM \n\t\tLEFT JOIN WHDrwA TD ON TM.DocEntry =TD.DocEntry \n\t\tGROUP BY TD.BaseEntry\n\t\tunion all \n\t\t--退料\n\t\tSELECT TD.BaseEntry ,MAX(TM.DocDate ) MAXDocDate,MIN(TM.DocDate ) MINDocDate\n\t\tFROM WHBak TM \n\t\tLEFT JOIN WHBakA TD ON TM.DocEntry =TD.DocEntry \n\t\tGROUP BY TD.BaseEntry\n\t\tunion all \n\t\t--入库\n\t\tSELECT TD.BaseEntry ,MAX(TM.DocDate ) MAXDocDate,MIN(TM.DocDate ) MINDocDate\n\t\tFROM WHPin TM \n\t\tLEFT JOIN WHPinA TD ON TM.DocEntry =TD.DocEntry \n\t\tGROUP BY TD.BaseEntry\n\t\tunion all \n\t\t--退制\n\t\tSELECT TD.BaseEntry ,MAX(TM.DocDate ) MAXDocDate,MIN(TM.DocDate ) MINDocDate\n\t\tFROM WHPou TM \n\t\tLEFT JOIN WHPouA TD ON TM.DocEntry =TD.DocEntry \n\t\tGROUP BY TD.BaseEntry\n\t\tunion all \n\t\t--外协入库\n\t\tSELECT TM3.BaseEntry ,MAX(TM2.DocDate ) MAXDocDate,MIN(TM2.DocDate ) MINDocDate\n\t\tFROM MNOrd TM \n\t\tLEFT JOIN MNOrdA TD ON TM.DocEntry =TD.DocEntry \n\t\tLEFT JOIN MNRevA TD2 ON TD2.BaseEntry =TD.DocEntry AND TD2.BaseType =TD.ObjType \n\t\tleft join MNRev TM2 ON TM2.DocEntry =TD2.DocEntry \n\t\tleft join ESPrd TM3 ON TM3.DocEntry =TD.BaseEntry \n\t\tGROUP BY TM3.BaseEntry\n\t\tunion all \n\t\t--外协退货\n\t\tSELECT TM3.BaseEntry ,MAX(TM2.DocDate ) MAXDocDate,MIN(TM2.DocDate ) MINDocDate\n\t\tFROM MNOrd TM \n\t\tLEFT JOIN MNOrdA TD ON TM.DocEntry =TD.DocEntry \n\t\tLEFT JOIN MNBakA TD2 ON TD2.BaseEntry =TD.DocEntry AND TD2.BaseType =TD.ObjType \n\t\tleft join MNBak TM2 ON TM2.DocEntry =TD2.DocEntry \n\t\tleft join ESPrd TM3 ON TM3.DocEntry =TD.BaseEntry \n\t\tGROUP BY TM3.BaseEntry\n\t\tunion all \n\t\t--外协赔偿\n\t\tSELECT TM3.BaseEntry ,MAX(TM2.DocDate ) MAXDocDate,MIN(TM2.DocDate ) MINDocDate\n\t\tFROM MNOrd TM \n\t\tLEFT JOIN MNOrdA TD ON TM.DocEntry =TD.DocEntry \n\t\tLEFT JOIN MNCmpA TD2 ON TD2.BaseEntry =TD.DocEntry AND TD2.BaseType =TD.ObjType \n\t\tleft join MNCmp TM2 ON TM2.DocEntry =TD2.DocEntry \n\t\tleft join ESPrd TM3 ON TM3.DocEntry =TD.BaseEntry \n\t\tGROUP BY TM3.BaseEntry\n\t\t--不考虑付品单据\n\t) S \n\tGROUP BY S.BaseEntry\n) S1 ON S1.BaseEntry=TM.DocEntry \nWHERE LEFT(CONVERT(varchar(12) , TM.FinishedDate, 112 ),6)=LEFT(CONVERT(varchar(12) , TM.DocDate, 112 ),6) AND TM2.AbsID 'X' \n group by TD.BaseType ,TD.BaseEntry ,TD.BaseLineNum )S10 on S10.BaseType=TD.ObjType and S10.BaseEntry=TD.DocEntry and S10.BaseLineNum =TD.LineNum \nwhere TM.AbsID>=@AbsIDFr and TM.AbsID<=@AbsIDTo and S10.MCSH>TD.ReqDate and TD.LineStatus not in ('A','X')\n--末次发货日期未超过需求日期(或尚未发货)，需求日期小于当前日期 ，但仍存在未清数，赋值1\nunion all \nselect TD.DocNum,TD.AbsID, 1 BS\nfrom SAOrdA TD\nleft join SAOrd TM on TM.DocEntry=TD.DocEntry \nleft join (select TD.BaseType ,TD.BaseEntry ,TD.BaseLineNum ,MAX(TM.DocDate) MCSH \n from SASAlA TD \n left join SASAl TM on TM.DocEntry=TD.DocEntry \n where TD.LineStatus<>'X' \n group by TD.BaseType ,TD.BaseEntry ,TD.BaseLineNum )S10 on S10.BaseType=TD.ObjType and S10.BaseEntry=TD.DocEntry and S10.BaseLineNum =TD.LineNum \nwhere TM.AbsID>=@AbsIDFr and TM.AbsID<=@AbsIDTo and (S10.MCSH<=TD.ReqDate or S10.MCSH is null) and TD.ReqDate'C' and TD.LineStatus not in ('A','X')\n--末次发货日期未超过需求日期(或尚未发货)，需求日期大于等于当前日期\n\nunion all \nselect TD.DocNum, TD.AbsiD,0 BS\nfrom SAOrdA TD\nleft join SAOrd TM on TM.DocEntry=TD.DocEntry \nleft join (select TD.BaseType ,TD.BaseEntry ,TD.BaseLineNum ,MAX(TM.DocDate) MCSH \n from SASAlA TD \n left join SASAl TM on TM.DocEntry=TD.DocEntry \n where TD.LineStatus<>'X' \n group by TD.BaseType ,TD.BaseEntry ,TD.BaseLineNum )S10 on S10.BaseType=TD.ObjType and S10.BaseEntry=TD.DocEntry and S10.BaseLineNum =TD.LineNum \nwhere TM.AbsID>=@AbsIDFr and TM.AbsID<=@AbsIDTo and (S10.MCSH<=TD.ReqDate or S10.MCSH is null) and TD.ReqDate>=GETDATE() and TD.LineStatus not in ('A','X')\n--末次发货日期未超过需求日期，需求日期小于当前日期 ，但已完结\nunion all \nselect TD.DocNum,TD.AbsID, 0 BS\nfrom SAOrdA TD\nleft join SAOrd TM on TM.DocEntry=TD.DocEntry \nleft join (select TD.BaseType ,TD.BaseEntry ,TD.BaseLineNum ,MAX(TM.DocDate) MCSH \n from SASAlA TD \n left join SASAl TM on TM.DocEntry=TD.DocEntry \n where TD.LineStatus<>'X' \n group by TD.BaseType ,TD.BaseEntry ,TD.BaseLineNum )S10 on S10.BaseType=TD.ObjType and S10.BaseEntry=TD.DocEntry and S10.BaseLineNum =TD.LineNum \nwhere TM.AbsID>=@AbsIDFr and TM.AbsID<=@AbsIDTo and (S10.MCSH<=TD.ReqDate or S10.MCSH is null) and TD.ReqDate=TD.Qty or TD.Linestatus='C' )and TD.LineStatus not in ('A','X')\n--考虑需求日期为空的,视为未达标\nunion all\nselect TD.DocNum ,TD.AbsID,1 BS\nfrom SAOrdA TD \nwhere TD.AbsID>=@AbsIDFr and TD.AbsID<=@AbsIDTo and TD.LineStatus not in ('A','X') and TD.ReqDate is null)S\n--明细子查询结束\nwhere S.BS=0\ngroup by S.DocNum,S.AbsID )SS\nleft join (select TM.absID,COUNT(TM.DocENtry) ZS from SAOrd TM where TM.AbsID>=@AbsIDFr and TM.AbsID<=@AbsIDTo group by TM.absID) TB on TB.AbsID =SS.AbsID \ngroup by SS.AbsID ,TB.ZS )S\n\n\n", "note": "", "created": "2026-09-18", "updated": "2026-09-18", "copies": 0 }, { "id": "S-24", "title": "从发票更新价格到采购收货", "db": "MySQL", "tags": "", "sql": "update TD SET \nTD.PriceFC = TD2.PriceFC,\nTD.Price = TD2.Price,\nTD.TaxAfPriceFC = TD2.TaxAfPriceFC,\nTD.TaxAfPrice = TD2.TaxAfPrice,\nTD.TaxAfLineSumFC = Round(TD2.TaxAfPriceFC * TD.Qty,2),\nTD.TaxAfLineSum = Round(TD2.TaxAfPrice * TD.Qty,2),\nTD.LineSumFC = Round(TD2.PriceFC*TD.Qty,2),\nTD.LineSum = Round(TD2.Price*TD.Qty,2),\nTD.TaxSumFC = Round(TD2.TaxAfPriceFC * TD.Qty,2)-Round(TD2.PriceFC*TD.Qty,2),\nTD.TaxSum = Round(TD2.TaxAfPrice * TD.Qty,2)-Round(TD2.Price*TD.Qty,2),\nTD.OpenSumFC = Round(TD2.TaxAfPriceFC * TD.OpenQty,2),\nTD.OpenSum = Round(TD2.TaxAfPrice * TD.OpenQty,2)\nfrom PRPinA TD \nleft join PUInvA TD2 on TD2.BaseType=TD.ObjType and TD2.BaseEntry=TD.DocEntry and TD2.BaseLineNum=TD.LineNum \nwhere TD.AbsID in ('202107','202108') and TD.Price=0\n\n\n--更新主单\nUpdate TM set \nTM.UnTaxTotal = S.LineSum, TM.UnTaxTotalFC = S.LineSumFC,\nTM.TaxTotal = S.TaxSum, TM.TaxTotalFC = S.TaxSumFC,\nTM.DocTotal = S.TaxAfLineSum, TM.DocTotalFC = S.TaxAfLineSumFC,\nTM.DocOpenTotal = S.OpenSum, TM.DocOpenTotalFC = S.OpenSumFC\nFrom PURev TM\n\tINNER JOIN\n\t(\n\t\tSelect TD.DocEntry,\n\t\tSum(TD.LineSum) LineSum,Sum(TD.LineSumFC) LineSumFC,\n\t\tSum(TD.TaxSum) TaxSum, Sum(TD.TaxSumFC) TaxSumFC,\n\t\tSum(TD.TaxAfLineSum) TaxAfLineSum, Sum(TD.TaxAfLineSumFC) TaxAfLineSumFC,\n\t\tSum(TD.OpenSum) OpenSum, Sum(TD.OpenSumFC) OpenSumFC\n\t\tFrom PURevA TD \n left join PURev TM on TM.DocEntry=TD.DocEntry\n where TD.AbsID in ('202107','202108')\n\t\tGroup by TD.DocEntry\n\t) S on TM.DocEntry = S.DocEntry\nWHERE TM.AbsID in ('202107','202108') and TM.UnTaxTotal <> S.LineSum\n", "note": "", "created": "2026-09-18", "updated": "2026-09-18", "copies": 0 }, { "id": "S-25", "title": "nextNum", "db": "MySQL", "tags": "", "sql": "AATblCd\nAATblKy\nAATblKm\nAATblCm", "note": "", "created": "2026-09-18", "updated": "2026-09-18", "copies": 0 }, { "id": "S-26", "title": "查询数据所占空间", "db": "MySQL", "tags": "", "sql": "CREATE TABLE #T (表名 nvarchar(100), 记录数 char(20), 保留 varchar(18) ,已使用 varchar(18) ,索引 varchar(18), 未用 varchar(18))\nGO \nINSERT #T EXEC SP_MSFOREACHTABLE 'EXEC sp_spaceused \"?\"'\n \nSELECT * FROM #T ORDER BY CONVERT(INT,REPLACE(已使用,'KB','')) DESC", "note": "", "created": "2026-09-18", "updated": "2026-09-18", "copies": 0 }, { "id": "S-27", "title": "假领假退单清理(含批次)", "db": "MSSQL", "tags": "", "sql": "--SELECT TM.NumAtCrd ,TD3.Batchnum,TD.*\ndelete TD3\nFROM WHDrwA TD \nleft join WHDrw TM on TM.DocEntry=TD.DocEntry \nleft join BCIbr TD1 ON TD1.BaseEntry=TD.DocEntry and TD1.BaseType=TD.ObjType and TD1.BaseLineNum=TD.LineNum\nleft join BCIbtA TD2 ON TD2.BaseEntry=TD1.DocEntry\nLEFT JOIN BCIbt TD3 ON TD3.DocKey=TD2.BaseDocKey AND TD3.BatchNum=TD2.BatchNum\nwhere TM.AbsID ='202207' and TM.DocKind=99\n\ndelete TD2\nFROM WHDrwA TD \nleft join WHDrw TM on TM.DocEntry=TD.DocEntry \nleft join BCIbr TD1 ON TD1.BaseEntry=TD.DocEntry and TD1.BaseType=TD.ObjType and TD1.BaseLineNum=TD.LineNum\nleft join BCIbtA TD2 ON TD2.BaseEntry=TD1.DocEntry\nLEFT JOIN BCIbt TD3 ON TD3.DocKey=TD2.BaseDocKey AND TD3.BatchNum=TD2.BatchNum\nwhere TM.AbsID ='202207' and TM.DocKind=99\n\ndelete TD1\nFROM WHDrwA TD \nleft join WHDrw TM on TM.DocEntry=TD.DocEntry \nleft join BCIbr TD1 ON TD1.BaseEntry=TD.DocEntry and TD1.BaseType=TD.ObjType and TD1.BaseLineNum=TD.LineNum\nleft join BCIbtA TD2 ON TD2.BaseEntry=TD1.DocEntry\nLEFT JOIN BCIbt TD3 ON TD3.DocKey=TD2.BaseDocKey AND TD3.BatchNum=TD2.BatchNum\nwhere TM.AbsID ='202207' and TM.DocKind=99\n\ndelete TD\nFROM WHDrwA TD \nleft join WHDrw TM on TM.DocEntry=TD.DocEntry \n\nwhere TM.AbsID ='202207' and TM.DocKind=99\n\ndelete TM\nFROM WHDrw TM\nwhere TM.AbsID ='202207' and TM.DocKind=99\n\n--SELECT TM.NumAtCrd ,TD3.Batchnum,TD.*\ndelete TD3\nFROM WHBakA TD \nleft join WHBak TM on TM.DocEntry=TD.DocEntry \nleft join BCIbr TD1 ON TD1.BaseEntry=TD.DocEntry and TD1.BaseType=TD.ObjType and TD1.BaseLineNum=TD.LineNum\nleft join BCIbtA TD2 ON TD2.BaseEntry=TD1.DocEntry\nLEFT JOIN BCIbt TD3 ON TD3.DocKey=TD2.BaseDocKey AND TD3.BatchNum=TD2.BatchNum\nwhere TM.AbsID ='202206' and TM.DocKind=99\n\ndelete TD2\nFROM WHBakA TD \nleft join WHBak TM on TM.DocEntry=TD.DocEntry \nleft join BCIbr TD1 ON TD1.BaseEntry=TD.DocEntry and TD1.BaseType=TD.ObjType and TD1.BaseLineNum=TD.LineNum\nleft join BCIbtA TD2 ON TD2.BaseEntry=TD1.DocEntry\nLEFT JOIN BCIbt TD3 ON TD3.DocKey=TD2.BaseDocKey AND TD3.BatchNum=TD2.BatchNum\nwhere TM.AbsID ='202206' and TM.DocKind=99\n\ndelete TD1\nFROM WHBakA TD \nleft join WHBak TM on TM.DocEntry=TD.DocEntry \nleft join BCIbr TD1 ON TD1.BaseEntry=TD.DocEntry and TD1.BaseType=TD.ObjType and TD1.BaseLineNum=TD.LineNum\nleft join BCIbtA TD2 ON TD2.BaseEntry=TD1.DocEntry\nLEFT JOIN BCIbt TD3 ON TD3.DocKey=TD2.BaseDocKey AND TD3.BatchNum=TD2.BatchNum\nwhere TM.AbsID ='202206' and TM.DocKind=99\n\ndelete TD\nFROM WHBakA TD \nleft join WHBak TM on TM.DocEntry=TD.DocEntry \nwhere TM.AbsID ='202206' and TM.DocKind=99\n\ndelete TM\nFROM WHBak TM\nwhere TM.AbsID ='202206' and TM.DocKind=99", "note": "", "created": "2026-09-18", "updated": "2026-09-18", "copies": 0 }, { "id": "S-28", "title": "75成本期初表", "db": "MSSQL", "tags": "", "sql": "\n制造成本相关：COAmt、COAmtA\n\n制造成本核算相关：COCos、COCosIn、COCosOu\n\n成本核算相关：COStk、COCst、COStkRu\n\n期初数据：COFinBe 、COCosBe\n\n\ndelete COAmt\ndelete COAmtA\ndelete COCos\ndelete COCosIn\ndelete COCosOu\n\n\ndelete COStk\ndelete COCst\ndelete COStkRu\n\n\ndelete COFinBe\ndelete COCosBe", "note": "", "created": "2026-09-18", "updated": "2026-09-18", "copies": 0 }, { "id": "S-29", "title": "结账表插数据", "db": "MSSQL", "tags": "", "sql": "--Insert Into AAFinWH\nSelect distinct TM.AbsID, TM.WhsID, TM.ItmID, 0 BeginQty, 0 BegiAmount, 0 BeginPrice, 0 InQty, 0 InAmount, 0 InAdjAmount, \n 0 OutQty, 0 OutAmount, 0 AdjAmount, 0 EndQty, 0 EndAmount, 0 EndPrice, 'N' IsOccur \nFrom COCos TM\nWhere TM.AbsID = 202201 and Not Exists\n(Select * from COStk S Where S.AbsID = 202201\n and TM.ItmID = S.ItmID and TM.WhsID = S.WhsID)", "note": "", "created": "2026-09-18", "updated": "2026-09-18", "copies": 0 }, { "id": "S-30", "title": "8系统从工艺路线同步到BOM", "db": "MSSQL", "tags": "", "sql": "--DELETE TD \n--From MDBomB TD\n--INNER JOIN MDBom TM on TD.DocEntry = TM.DocEntry \n--left join BOMLK TB on TB.BomID=TM.BomID\n--Where TB.BomID=TM.BomID\nset identity_insert MDBomB ON\nINSERT INTO MDBomB ( LineKey,DocEntry,LineNum,PrcID,PrcName,WcnID,WcnName,PreLineNum,Relation,Priority,\nDelayHour,BatchQty,WorkTime,WaitTime,TransTime,PreHour1,PreHour2,MaintenCount,MaintenTime,\nIsMainten,ModID,ModTypeID,MacID,MacName,ScrapRate,ScrapQty,RoundType,RoundScale,\nFlushType,WcnNum,WcnLoadPct,QtyTimes,QtyPMod,RateWeight,OpnCount,WrkPrice,ProcPrice,\nCompPrice,CurrID,PrcUnit,QtyRate,SkipSign,SkipTsf,IsOutSplit,IsSup,IsPc,AutoCloseTolen,\nCloseTolenTop,CloseTolenBttm,CloseTolenExcept,FreeTxt )\n\nSelect \t\nS.LineKey +ROW_NUMBER() OVER (ORDER BY TB2.DocEntry,TB.LineNum ) as Linekey, \n TB2.DocEntry , TB.LineNum,TB.PrcID,TB.PrcName,TB.WcnID,TB.WcnName\n,TB.PreLineNum,TB.Relation,TB.Priority,\nTB.DelayHour,TB.BatchQty,TB.WorkTime,TB.WaitTime,TB.TransTime,TB.PreHour1\n,TB.PreHour2,TB.MaintenCount,TB.MaintenTime,\nTB.IsMainten,TB.ModID,TB.ModTypeID,TB.MacID,TB.MacName,TB.ScrapRate,TB.ScrapQty\n,TB.RoundType,TB.RoundScale,\nTB.FlushType,TB.WcnNum,TB.WcnLoadPct,TB.QtyTimes,TB.QtyPMod,TB.RateWeight,TB.OpnCount\n,TB.WrkPrice,TB.ProcPrice,\nTB.CompPrice,TB.CurrID,TB.PrcUnit,1 QtyRate,TB.SkipSign,TB.SkipTsf,TB.IsOutSplit\n,TB.IsSup,TB.IsPc,TB.AutoCloseTolen,\nTB.CloseTolenTop,TB.CloseTolenBttm,TB.CloseTolenExcept,TB.FreeTxt\nFrom MDBom TB2\nINNER JOIN MDRouA TB on TB2.RouID = TB.RouID \nleft join BOMLK TB3 on TB3.BomID=TB2.BomID\nleft join (select MAX(TD.LineKey) LineKey from MDBomB TD) S on 1=1\nwhere TB3.BomID=TB2.BomID\nset identity_insert MDBomB off", "note": "", "created": "2026-09-18", "updated": "2026-09-18", "copies": 0 }, { "id": "S-31", "title": "查询表字段类型", "db": "MSSQL", "tags": "", "sql": "select TB.[name] as TableName, TC.[name] as FieldName, TT.[name] as [Type], TC.length, \n TD.Definition as [Default], TP.[Value] as Description, Tc.IsNullable\nfrom sys.tables TB left join sys.syscolumns TC on TB.object_id = TC.id\n\t\t\t\t left join sys.systypes TT on TT.XUserType = TC.XUserType\n\t\t\t\t left join sys.default_constraints TD on TC.cdefault = TD.object_id\n\t\t\t\t left join sys.extended_properties TP \n\t\t\t\t\t\ton TB.object_id = TP.major_id and TC.colid = TP.minor_id\nWhere TB.[name] like '表名%'\nOrder By TB.[name], TC.ColId", "note": "", "created": "2026-09-18", "updated": "2026-09-18", "copies": 0 }, { "id": "S-32", "title": "获取数据库独占语句", "db": "MSSQL", "tags": "", "sql": "\nALTER DATABASE DEMO \nSET OFFLINE WITH ROLLBACK IMMEDIATE", "note": "", "created": "2026-09-18", "updated": "2026-09-18", "copies": 0 }, { "id": "S-33", "title": "重算机器生产指标", "db": "MSSQL", "tags": "", "sql": "update TM set \n--负荷率=工作时间/班次时间\nTM.RateL=TM.ShiftWorkHour /TM.ShiftHour\n--稼动率=加工时间/工作时间\n,TM.RateA=TM.WorkHour/TM.ShiftWorkHour\n --产能效率=数量工时/加工时间（注：数量工时=工单工序标准作业时间/工单工序制造批量*SUM(任务明细（实际产出+工废+料废）））\n ,TM.RateP=TM.CycHour/TM.WorkHour\n --良品率=实际产出/（实际产出+工废+料废）\n,TM.RateQ=TM.OutQty/(TM.OutQty+TM.DefectWQty+TM.DefectMQty)\n--设备效率(OEE)=稼动率*产能效率*良品率\n ,TM.RateOEE=(TM.CycHour/TM.WorkHour)*(TM.WorkHour/TM.ShiftWorkHour)*(TM.OutQty/(TM.OutQty+TM.DefectWQty+TM.DefectMQty))\n--综合效率=设备效率*负荷率\n,TM.RateTEEP=(TM.CycHour/TM.WorkHour)*(TM.WorkHour/TM.ShiftWorkHour)*(TM.OutQty/(TM.OutQty+TM.DefectWQty+TM.DefectMQty))*(TM.ShiftWorkHour /TM.ShiftHour)\n \nfrom EAKpi TM", "note": "", "created": "2026-09-18", "updated": "2026-09-18", "copies": 0 }, { "id": "S-34", "title": "数据重要字段变更批量加字段", "db": "MSSQL", "tags": "", "sql": "\ninsert into AAChgB\nselect \n'10002' ChangeID ,\nROW_NUMBER () over (order by TM.FieldName)+526 LineNum ,\nTM.TableID +'.'+TM.FieldName RowDesc\n,'if Exists(Select * from sys.tables T0 where T0.Name = '''+TM.TableID+''') Begin Update '+TM.TableID+' set '+TM.FieldName+' = @NewItmID where '+TM.FieldName+' = @ItmID End' SqlString ,\n '更新表'+TM.TableID+', 影响行数[@RowCount]' ExMessage \nfrom AATblFd TM \nLEFT JOIN \n\t(\n\tselect *\n\tfrom AAChgB TM \n\tWHERE TM.ChangeID ='10002'\n\t) T1 ON T1.RowDesc =TM.TableID +'.'+TM.FieldName \nWHERE (TM.FieldName LIKE '%BomID%' OR TM.FieldName LIKE '%ItmID%' ) and TM.FieldName <>'PtlItmID'\nAND T1.ChangeID IS NULL \n\n\n\n\n--select *\n--from AAChgB TM \n--WHERE TM.ChangeID ='10002'\n", "note": "", "created": "2026-09-18", "updated": "2026-09-18", "copies": 0 }, { "id": "S-35", "title": "清理工单用料重复行", "db": "MSSQL", "tags": "", "sql": "--delete\nselect DocEntry,Linekey\nfrom MDBomA\nwhere LineKey NOT IN (\nselect \n(select MIN(Linekey) from MDBomA where DocEntry = S1.DocEntry and ItmID = S1.ItmID and ISNULL(Position,0)= ISNULL(S1.Position,0)) Linekey\nfrom\n(select DISTINCT DocEntry ,ItmID,Position\nfrom MDBomA\ngroup by DocEntry ,ItmID,Position) S1\n)", "note": "", "created": "2026-09-18", "updated": "2026-09-18", "copies": 0 }, { "id": "S-36", "title": "权限结构相关表", "db": "MSSQL", "tags": "", "sql": "select * from AAOrg \nselect * from AARol\nselect * from AARolA\nselect * from AAJob\nselect * from AAJobGp\nselect * from AAUsr\nselect * from AAUsrRl\n\n\n组织架构迁移\n--清理组织架构表、组织对应岗位表、岗位角色表\ndelete tM from AAOrg TM\ndelete TM from AARol TM\ndelete TM from AARolA TM\n--从万盛亿账套分别插入对应表的数据\ninsert into AAOrg \nselect * from SZ_WSY.dbo.AAOrg \n\ninsert into AARol \nselect * from SZ_WSY.dbo.AARol \n\ninsert into AARolA \nselect * from SZ_WSY.dbo.AARolA ", "note": "", "created": "2026-09-18", "updated": "2026-09-18", "copies": 0 }, { "id": "S-37", "title": "索引重建", "db": "MSSQL", "tags": "", "sql": "DBCC DBREINDEX('AErp_History.dbo.AAHis')\n\nDBCC DBREINDEX('COCst')\nDBCC DBREINDEX('COCst')\n\nDBCC DBREINDEX('WHptm')\nDBCC DBREINDEX('WHptmA')\n\nDBCC DBREINDEX('WHpin')\nDBCC DBREINDEX('WHpinA')\n\n\nDBCC DBREINDEX('WHPou')\nDBCC DBREINDEX('WHPouA')\n\nDBCC DBREINDEX('MMOrd')\nDBCC DBREINDEX('MMOrdA')\nDBCC DBREINDEX('MMOrdB')\n\n\n\nDBCC DBREINDEX('WHDrw')\nDBCC DBREINDEX('WHDrwA')\n\n\nDBCC DBREINDEX('WHBakA')\nDBCC DBREINDEX('WHBak')\n\n\nDBCC DBREINDEX('SAOrdA')\nDBCC DBREINDEX('SAOrd')\n\nDBCC DBREINDEX('SATMp')\nDBCC DBREINDEX('SATmpA')\nDBCC DBREINDEX('SATmpG')\n\n\n\nDBCC DBREINDEX('SASal')\nDBCC DBREINDEX('SASalA')\n\nDBCC DBREINDEX('SABAk')\nDBCC DBREINDEX('SABAkA')\n\nDBCC DBREINDEX('SARec')\nDBCC DBREINDEX('SARecA')\nDBCC DBREINDEX('SARecG')\n\n\nDBCC DBREINDEX('SAInv')\nDBCC DBREINDEX('SAInvA')\n\n\nDBCC DBREINDEX('PUOrd')\nDBCC DBREINDEX('PUordA')\n\n\n\nDBCC DBREINDEX('PUTmp')\nDBCC DBREINDEX('PUTmpA')\n\n\n\nDBCC DBREINDEX('PURev')\nDBCC DBREINDEX('PUrevA')\n\n\nDBCC DBREINDEX('PUrec')\nDBCC DBREINDEX('PUrecA')\n\n\nDBCC DBREINDEX('PUInv')\nDBCC DBREINDEX('PUInvA')\n\n\n\n\n\n\nDBCC DBREINDEX('MDItm')\nDBCC DBREINDEX('MDLstA')\n\n\nDBCC DBREINDEX('BCIBt')\nDBCC DBREINDEX('BCIbtA')\nDBCC DBREINDEX('BCIBr')\n\nDBCC DBREINDEX('MMPsc')\nDBCC DBREINDEX('MMPscA')\n\n\nDBCC DBREINDEX('MMPou')\nDBCC DBREINDEX('MMpouA')\n\n\n\nDBCC DBREINDEX('WHoinA')\nDBCC DBREINDEX('WHOin')\n\n\n\nDBCC DBREINDEX('WHOou')\nDBCC DBREINDEX('WHOouA')\n\n\n\n\n\n\n\n\n\n\n", "note": "", "created": "2026-09-18", "updated": "2026-09-18", "copies": 0 }, { "id": "S-38", "title": "截取固定符号前", "db": "MSSQL", "tags": "", "sql": "dbo.BarCodeAt(@BatchNum, '-', 1)", "note": "", "created": "2026-09-18", "updated": "2026-09-18", "copies": 0 }, { "id": "S-39", "title": "单据启用JS", "db": "MSSQL", "tags": "", "sql": "Update NTUrl set IsExtJs = 'Y' where ObjType = ''", "note": "", "created": "2026-09-18", "updated": "2026-09-18", "copies": 0 }, { "id": "S-40", "title": "启用外部邮箱个人设置", "db": "MSSQL", "tags": "", "sql": "Select IsSendApprove, IsSendNotify, IsSendNormal, IsSendOutMail, *\n\n--Update TA set IsSendApprove = 'Y', IsSendNotify = 'Y', IsSendNormal = 'Y', IsSendOutMail = 'Y',OutOffice='Y'\n\nFrom AAUsrSe TA\n\nWhere UserID = ''", "note": "", "created": "2026-09-18", "updated": "2026-09-18", "copies": 0 }, { "id": "S-41", "title": "更新查询中是否系统", "db": "MSSQL", "tags": "", "sql": "Update TD\nset TD.IsSystem='N'\nfrom AARefZb TD\nwhere TD.ReferenceID='3453'", "note": "", "created": "2026-09-18", "updated": "2026-09-18", "copies": 0 }, { "id": "S-42", "title": "合并备注", "db": "MSSQL", "tags": "", "sql": "select ('['+TM.FreeTxt+']')\nfrom ESBpdP TM\nleft join ESBpdQ TD on TM.DocEntry = TD.DocEntry and TM.OrderEntry = TD.OrderEntry\nwhere TM.DocEntry = 10173 and TM.DocEntry = TD.DocEntry and TM.OrderEntry = TD.OrderEntry and ISNULL(TM.FreeTxt,'')<>''\nFOR XML PATH('')\n", "note": "", "created": "2026-09-18", "updated": "2026-09-18", "copies": 0 }, { "id": "S-43", "title": "重置密码", "db": "MSSQL", "tags": "", "sql": "update AASuper set Password='So3eRiRa0CY='where SuperID='Admin'-----重置系统管理超级密码为789\nupdate AAUsr set Password='So3eRiRa0CY='where UserID='Admin'-----重置老系统管理密码\n", "note": "", "created": "2026-09-18", "updated": "2026-09-18", "copies": 0 }, { "id": "S-44", "title": "固资清空语句 (1)", "db": "MSSQL", "tags": "", "sql": "--清空固资主数据及实物信息\nTruncate Table FXAst\nTruncate Table FXAstB\n--清空结账数据\nTruncate Table FXBal\nTruncate Table FXAstA\n--清空折旧信息\nTruncate Table FXDpr\nTruncate Table FXDprA\n--清空折旧调整信息\nTruncate Table FXDpj\nTruncate Table FXDpjA\n--清空固资调整信息\nTruncate Table FXAdj\nTruncate Table FXAdjA\n--清空固资处置信息\nTruncate Table FXDps\nTruncate Table FXDpsA\n--清空折旧分单信息\nTruncate Table FXDpc\n--清空履历表\nTruncate Table FXAstZ", "note": "", "created": "2026-09-18", "updated": "2026-09-18", "copies": 0 }, { "id": "S-45", "title": "批量更改名称语句", "db": "MSSQL", "tags": "", "sql": "if Exists(Select * from sys.tables T0 where T0.Name = 'WHOinG') Begin Update WHOinG set ItmName = T1.NewItmName from WHOinG T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'WHOouA') Begin Update WHOouA set ItmName = T1.NewItmName from WHOouA T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'WHOouF') Begin Update WHOouF set ItmName = T1.NewItmName from WHOouF T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'WHOouG') Begin Update WHOouG set ItmName = T1.NewItmName from WHOouG T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'WHPinA') Begin Update WHPinA set ItmName = T1.NewItmName from WHPinA T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'WHPinF') Begin Update WHPinF set ItmName = T1.NewItmName from WHPinF T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'WHPinG') Begin Update WHPinG set ItmName = T1.NewItmName from WHPinG T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'WHPouA') Begin Update WHPouA set ItmName = T1.NewItmName from WHPouA T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'WHPouF') Begin Update WHPouF set ItmName = T1.NewItmName from WHPouF T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'WHPouG') Begin Update WHPouG set ItmName = T1.NewItmName from WHPouG T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'WHPtbA') Begin Update WHPtbA set ItmName = T1.NewItmName from WHPtbA T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'WHPtbF') Begin Update WHPtbF set ItmName = T1.NewItmName from WHPtbF T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'WHPtbG') Begin Update WHPtbG set ItmName = T1.NewItmName from WHPtbG T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'WHPtmA') Begin Update WHPtmA set ItmName = T1.NewItmName from WHPtmA T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'PMPrjC') Begin Update PMPrjC set ItmName = T1.NewItmName from PMPrjC T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'PMPrjF') Begin Update PMPrjF set ItmName = T1.NewItmName from PMPrjF T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'PMPrjG') Begin Update PMPrjG set ItmName = T1.NewItmName from PMPrjG T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'PRCavF') Begin Update PRCavF set ItmName = T1.NewItmName from PRCavF T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'PRCavG') Begin Update PRCavG set ItmName = T1.NewItmName from PRCavG T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'PRDrcF') Begin Update PRDrcF set ItmName = T1.NewItmName from PRDrcF T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'PRDrcG') Begin Update PRDrcG set ItmName = T1.NewItmName from PRDrcG T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'PRExcF') Begin Update PRExcF set ItmName = T1.NewItmName from PRExcF T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'PRExcG') Begin Update PRExcG set ItmName = T1.NewItmName from PRExcG T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'PRPayF') Begin Update PRPayF set ItmName = T1.NewItmName from PRPayF T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'PRPayG') Begin Update PRPayG set ItmName = T1.NewItmName from PRPayG T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'PRPinA') Begin Update PRPinA set ItmName = T1.NewItmName from PRPinA T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'PRPinF') Begin Update PRPinF set ItmName = T1.NewItmName from PRPinF T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'PRPinG') Begin Update PRPinG set ItmName = T1.NewItmName from PRPinG T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'PRPrpF') Begin Update PRPrpF set ItmName = T1.NewItmName from PRPrpF T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'PRPrpG') Begin Update PRPrpG set ItmName = T1.NewItmName from PRPrpG T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'PRRecF') Begin Update PRRecF set ItmName = T1.NewItmName from PRRecF T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'PRRecG') Begin Update PRRecG set ItmName = T1.NewItmName from PRRecG T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'PRSinA') Begin Update PRSinA set ItmName = T1.NewItmName from PRSinA T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'PRSinF') Begin Update PRSinF set ItmName = T1.NewItmName from PRSinF T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'PRSinG') Begin Update PRSinG set ItmName = T1.NewItmName from PRSinG T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'PUAdjA') Begin Update PUAdjA set ItmName = T1.NewItmName from PUAdjA T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'PUAdjF') Begin Update PUAdjF set ItmName = T1.NewItmName from PUAdjF T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'PUAdjG') Begin Update PUAdjG set ItmName = T1.NewItmName from PUAdjG T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'PUBakA') Begin Update PUBakA set ItmName = T1.NewItmName from PUBakA T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'PUBakF') Begin Update PUBakF set ItmName = T1.NewItmName from PUBakF T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'PUBakG') Begin Update PUBakG set ItmName = T1.NewItmName from PUBakG T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'PUInvA') Begin Update PUInvA set ItmName = T1.NewItmName from PUInvA T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'PUInvF') Begin Update PUInvF set ItmName = T1.NewItmName from PUInvF T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'PUInvG') Begin Update PUInvG set ItmName = T1.NewItmName from PUInvG T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'PUOrdA') Begin Update PUOrdA set ItmName = T1.NewItmName from PUOrdA T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'PUOrdF') Begin Update PUOrdF set ItmName = T1.NewItmName from PUOrdF T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'PUOrdG') Begin Update PUOrdG set ItmName = T1.NewItmName from PUOrdG T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'PURecA') Begin Update PURecA set ItmName = T1.NewItmName from PURecA T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'PURecF') Begin Update PURecF set ItmName = T1.NewItmName from PURecF T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'PURecG') Begin Update PURecG set ItmName = T1.NewItmName from PURecG T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'PUReqA') Begin Update PUReqA set ItmName = T1.NewItmName from PUReqA T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'PUReqF') Begin Update PUReqF set ItmName = T1.NewItmName from PUReqF T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'PUReqG') Begin Update PUReqG set ItmName = T1.NewItmName from PUReqG T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'PURevA') Begin Update PURevA set ItmName = T1.NewItmName from PURevA T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'PURevF') Begin Update PURevF set ItmName = T1.NewItmName from PURevF T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'PURevG') Begin Update PURevG set ItmName = T1.NewItmName from PURevG T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'PURfqA') Begin Update PURfqA set ItmName = T1.NewItmName from PURfqA T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'PURfrA') Begin Update PURfrA set ItmName = T1.NewItmName from PURfrA T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'PURfs') Begin Update PURfs set ItmName = T1.NewItmName from PURfs T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'PUTbkA') Begin Update PUTbkA set ItmName = T1.NewItmName from PUTbkA T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'PUTbkF') Begin Update PUTbkF set ItmName = T1.NewItmName from PUTbkF T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'PUTbkG') Begin Update PUTbkG set ItmName = T1.NewItmName from PUTbkG T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'PUTmpA') Begin Update PUTmpA set ItmName = T1.NewItmName from PUTmpA T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'PUTmpF') Begin Update PUTmpF set ItmName = T1.NewItmName from PUTmpF T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'PUTmpG') Begin Update PUTmpG set ItmName = T1.NewItmName from PUTmpG T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'SAAdjA') Begin Update SAAdjA set ItmName = T1.NewItmName from SAAdjA T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'SAAdjF') Begin Update SAAdjF set ItmName = T1.NewItmName from SAAdjF T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'SAAdjG') Begin Update SAAdjG set ItmName = T1.NewItmName from SAAdjG T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'SABakA') Begin Update SABakA set ItmName = T1.NewItmName from SABakA T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'SABakF') Begin Update SABakF set ItmName = T1.NewItmName from SABakF T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'SABakG') Begin Update SABakG set ItmName = T1.NewItmName from SABakG T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'SAInvA') Begin Update SAInvA set ItmName = T1.NewItmName from SAInvA T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'SAInvF') Begin Update SAInvF set ItmName = T1.NewItmName from SAInvF T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'SAInvG') Begin Update SAInvG set ItmName = T1.NewItmName from SAInvG T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'SAOrdA') Begin Update SAOrdA set ItmName = T1.NewItmName from SAOrdA T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'SAOrdF') Begin Update SAOrdF set ItmName = T1.NewItmName from SAOrdF T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'SAOrdG') Begin Update SAOrdG set ItmName = T1.NewItmName from SAOrdG T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'SAQutA') Begin Update SAQutA set ItmName = T1.NewItmName from SAQutA T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'SAQutAM') Begin Update SAQutAM set ItmName = T1.NewItmName from SAQutAM T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'SAQutF') Begin Update SAQutF set ItmName = T1.NewItmName from SAQutF T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'SAQutG') Begin Update SAQutG set ItmName = T1.NewItmName from SAQutG T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'SARecA') Begin Update SARecA set ItmName = T1.NewItmName from SARecA T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'SARecF') Begin Update SARecF set ItmName = T1.NewItmName from SARecF T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'SARecG') Begin Update SARecG set ItmName = T1.NewItmName from SARecG T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'SASalA') Begin Update SASalA set ItmName = T1.NewItmName from SASalA T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'SASalF') Begin Update SASalF set ItmName = T1.NewItmName from SASalF T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'SASalG') Begin Update SASalG set ItmName = T1.NewItmName from SASalG T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'SATbkA') Begin Update SATbkA set ItmName = T1.NewItmName from SATbkA T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'SATbkF') Begin Update SATbkF set ItmName = T1.NewItmName from SATbkF T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'SATbkG') Begin Update SATbkG set ItmName = T1.NewItmName from SATbkG T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'SATmpA') Begin Update SATmpA set ItmName = T1.NewItmName from SATmpA T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'SATmpF') Begin Update SATmpF set ItmName = T1.NewItmName from SATmpF T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'SATmpG') Begin Update SATmpG set ItmName = T1.NewItmName from SATmpG T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'WHAltA') Begin Update WHAltA set ItmName = T1.NewItmName from WHAltA T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'WHAltF') Begin Update WHAltF set ItmName = T1.NewItmName from WHAltF T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'WHAltG') Begin Update WHAltG set ItmName = T1.NewItmName from WHAltG T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'WHBakA') Begin Update WHBakA set ItmName = T1.NewItmName from WHBakA T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'WHBakF') Begin Update WHBakF set ItmName = T1.NewItmName from WHBakF T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'WHPtmF') Begin Update WHPtmF set ItmName = T1.NewItmName from WHPtmF T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'WHPtmG') Begin Update WHPtmG set ItmName = T1.NewItmName from WHPtmG T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'WHRetA') Begin Update WHRetA set ItmName = T1.NewItmName from WHRetA T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'WHRetF') Begin Update WHRetF set ItmName = T1.NewItmName from WHRetF T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'WHRetG') Begin Update WHRetG set ItmName = T1.NewItmName from WHRetG T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'WHScpA') Begin Update WHScpA set ItmName = T1.NewItmName from WHScpA T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'WHScpF') Begin Update WHScpF set ItmName = T1.NewItmName from WHScpF T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'WHScpG') Begin Update WHScpG set ItmName = T1.NewItmName from WHScpG T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'WHSinA') Begin Update WHSinA set ItmName = T1.NewItmName from WHSinA T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'WHSinF') Begin Update WHSinF set ItmName = T1.NewItmName from WHSinF T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'WHSinG') Begin Update WHSinG set ItmName = T1.NewItmName from WHSinG T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'WHSouA') Begin Update WHSouA set ItmName = T1.NewItmName from WHSouA T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'WHSouF') Begin Update WHSouF set ItmName = T1.NewItmName from WHSouF T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'WHSouG') Begin Update WHSouG set ItmName = T1.NewItmName from WHSouG T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'WHWinA') Begin Update WHWinA set ItmName = T1.NewItmName from WHWinA T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'WHWinF') Begin Update WHWinF set ItmName = T1.NewItmName from WHWinF T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'WHWinG') Begin Update WHWinG set ItmName = T1.NewItmName from WHWinG T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'WHWouA') Begin Update WHWouA set ItmName = T1.NewItmName from WHWouA T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'WHWouF') Begin Update WHWouF set ItmName = T1.NewItmName from WHWouF T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'WHWouG') Begin Update WHWouG set ItmName = T1.NewItmName from WHWouG T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'BCIbr') Begin Update BCIbr set ItmName = T1.NewItmName from BCIbr T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'CBAltF') Begin Update CBAltF set ItmName = T1.NewItmName from CBAltF T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'CBAltG') Begin Update CBAltG set ItmName = T1.NewItmName from CBAltG T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'CBExpF') Begin Update CBExpF set ItmName = T1.NewItmName from CBExpF T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'CBExpG') Begin Update CBExpG set ItmName = T1.NewItmName from CBExpG T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'CBIncF') Begin Update CBIncF set ItmName = T1.NewItmName from CBIncF T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'CBIncG') Begin Update CBIncG set ItmName = T1.NewItmName from CBIncG T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'COAdjA') Begin Update COAdjA set ItmName = T1.NewItmName from COAdjA T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'COAdjF') Begin Update COAdjF set ItmName = T1.NewItmName from COAdjF T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'COAdjG') Begin Update COAdjG set ItmName = T1.NewItmName from COAdjG T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'COCadA') Begin Update COCadA set ItmName = T1.NewItmName from COCadA T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'COPipA') Begin Update COPipA set ItmName = T1.NewItmName from COPipA T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'COWipA') Begin Update COWipA set ItmName = T1.NewItmName from COWipA T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'MAFixF') Begin Update MAFixF set ItmName = T1.NewItmName from MAFixF T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'MAFixG') Begin Update MAFixG set ItmName = T1.NewItmName from MAFixG T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'MAOinF') Begin Update MAOinF set ItmName = T1.NewItmName from MAOinF T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'MAOinG') Begin Update MAOinG set ItmName = T1.NewItmName from MAOinG T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'MAOouF') Begin Update MAOouF set ItmName = T1.NewItmName from MAOouF T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'MAOouG') Begin Update MAOouG set ItmName = T1.NewItmName from MAOouG T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'MAOrdF') Begin Update MAOrdF set ItmName = T1.NewItmName from MAOrdF T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'MAOrdG') Begin Update MAOrdG set ItmName = T1.NewItmName from MAOrdG T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'MDBomA') Begin Update MDBomA set ItmName = T1.NewItmName from MDBomA T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'MDBomRp') Begin Update MDBomRp set ItmName = T1.NewItmName from MDBomRp T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'MDItm') Begin Update MDItm set ItmName = T1.NewItmName from MDItm T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'MDItmPN') Begin Update MDItmPN set ItmName = T1.NewItmName from MDItmPN T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'WHBakG') Begin Update WHBakG set ItmName = T1.NewItmName from WHBakG T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'WHBrwA') Begin Update WHBrwA set ItmName = T1.NewItmName from WHBrwA T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'WHBrwF') Begin Update WHBrwF set ItmName = T1.NewItmName from WHBrwF T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'WHBrwG') Begin Update WHBrwG set ItmName = T1.NewItmName from WHBrwG T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'WHChkA') Begin Update WHChkA set ItmName = T1.NewItmName from WHChkA T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'WHChkF') Begin Update WHChkF set ItmName = T1.NewItmName from WHChkF T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'WHChkG') Begin Update WHChkG set ItmName = T1.NewItmName from WHChkG T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'WHDrwA') Begin Update WHDrwA set ItmName = T1.NewItmName from WHDrwA T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'WHDrwF') Begin Update WHDrwF set ItmName = T1.NewItmName from WHDrwF T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'WHDrwG') Begin Update WHDrwG set ItmName = T1.NewItmName from WHDrwG T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'WHMioA') Begin Update WHMioA set ItmName = T1.NewItmName from WHMioA T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'WHMioF') Begin Update WHMioF set ItmName = T1.NewItmName from WHMioF T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'WHMioG') Begin Update WHMioG set ItmName = T1.NewItmName from WHMioG T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'WHOinA') Begin Update WHOinA set ItmName = T1.NewItmName from WHOinA T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'WHOinF') Begin Update WHOinF set ItmName = T1.NewItmName from WHOinF T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'MDItmRp') Begin Update MDItmRp set ItmName = T1.NewItmName from MDItmRp T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'MDItmSN') Begin Update MDItmSN set ItmName = T1.NewItmName from MDItmSN T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'MMOrd') Begin Update MMOrd set ItmName = T1.NewItmName from MMOrd T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'MMOrdA') Begin Update MMOrdA set ItmName = T1.NewItmName from MMOrdA T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'MMOrdF') Begin Update MMOrdF set ItmName = T1.NewItmName from MMOrdF T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'MMOrdG') Begin Update MMOrdG set ItmName = T1.NewItmName from MMOrdG T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'MMPinF') Begin Update MMPinF set ItmName = T1.NewItmName from MMPinF T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'MMPinG') Begin Update MMPinG set ItmName = T1.NewItmName from MMPinG T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'MMPouF') Begin Update MMPouF set ItmName = T1.NewItmName from MMPouF T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'MMPouG') Begin Update MMPouG set ItmName = T1.NewItmName from MMPouG T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'MMPscF') Begin Update MMPscF set ItmName = T1.NewItmName from MMPscF T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'MMPscG') Begin Update MMPscG set ItmName = T1.NewItmName from MMPscG T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'MMSubA') Begin Update MMSubA set ItmName = T1.NewItmName from MMSubA T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'MMSupA') Begin Update MMSupA set ItmName = T1.NewItmName from MMSupA T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'MRPlnA') Begin Update MRPlnA set ItmName = T1.NewItmName from MRPlnA T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'MRPlnF') Begin Update MRPlnF set ItmName = T1.NewItmName from MRPlnF T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\nif Exists(Select * from sys.tables T0 where T0.Name = 'MRPlnG') Begin Update MRPlnG set ItmName = T1.NewItmName from MRPlnG T left join Tmp99 T1 on T1.ItmID=T.ItmID where T1.ItmID=T.ItmID End\n", "note": "", "created": "2026-09-18", "updated": "2026-09-18", "copies": 0 }, { "id": "S-46", "title": "同步工艺路线到BOM", "db": "MSSQL", "tags": "", "sql": "DELETE TD \nFrom MDBomB TD\nINNER JOIN MDBom TM on TD.DocEntry = TM.DocEntry \nWhere TM.RouID = @RouID\n\nINSERT INTO MDBomB ( DocEntry, LineNum, PrcID, PrcName, WcnID, WcnName,\n\t\t\t\t\t PreLineNum, Relation, Priority, DelayHour, BatchQty,\n\t\t\t\t\t WorkTime, WaitTime, TransTime, MaintenCount, IsMainten,\n\t\t\t\t\t Price, FreeTxt, ScrapRate, ScrapQty, RoundType,\n\t\t\t\t\t RoundScale, FlushType, AutoCloseTolen, CloseTolenTop,\n\t\t\t\t\t CloseTolenBttm, CloseTolenExcept, ModTypeID, WcnNum,\n\t\t\t\t\t WcnLoadPct, WrkPrice, SubPrice, CurrID, PrcUnit, QtyRate,\n\t\t\t\t\t ProcPrice, CompPrice, InstID, ResGrpID,\n\t\t\t\t\t ResGrpName, MaintenTime, MaxDelay, IsCycSBuff,\n\t\t\t\t\t IsCycEBuff, SBuffTime, EBuffTime, IsSchedule, SkipSign,\n\t\t\t\t\t MAMac )\nSelect \t TB2.DocEntry , TB.LineNum, TB.PrcID, TB.PrcName, TB.WcnID, TB.WcnName,\n\t\tTB.PreLineNum, TB.Relation, TB.Priority, TB.DelayHour, TB.BatchQty,\n\t\tTB.WorkTime, TB.WaitTime, TB.TransTime, TB.MaintenCount, TB.IsMainten,\n\t\tTB.Price, TB.FreeTxt, TB.ScrapRate, TB.ScrapQty, TB.RoundType,\n\t\tTB.RoundScale, TB.FlushType, TB.AutoCloseTolen, TB.CloseTolenTop,\n\t\tTB.CloseTolenBttm, TB.CloseTolenExcept, TB.ModTypeID, 1,\n\t\t1,TB.WrkPrice,TB.SubPrice, TB.CurrID, TB.PrcUnit, 1,\n\t\tTB.ProcPrice, TB.CompPrice,TB.InstID,TB.ResGrpID,\n\t\tTB.ResGrpName, TB.MaintenTime, TB.MaxDelay, TB.IsCycSBuff,\n\t\tTB.IsCycEBuff, TB.SBuffTime, TB.EBuffTime, TB.IsSchedule,TB.SkipSign,--TB.MAMac 豸\nFrom MDBom TB2\nINNER JOIN MDRouA TB on TB2.RouID = TB.RouID \nWhere TB.RouID = @RouID\n\nUpdate TM \nSet TM.ProcTotal = TD.ProcTotal,TM.WrkTotal = TD.WrkTotal, TM.LogInstanc = TM.LogInstanc + 1 \nFrom MDBom TM\nLEFT JOIN (\n\t\tSelect TD.DocEntry, Sum(IsNull(TD.ProcPrice,0)) as ProcTotal, Sum(IsNull(TD.WrkPrice,0)) as WrkTotal\n\t\tFrom MDBomB TD \n\t\tGroup by TD.DocEntry\n\t\t) TD on TD.DocEntry = TM.DocEntry\nWhere TM.RouID = @RouID", "note": "", "created": "2026-09-18", "updated": "2026-09-18", "copies": 0 }, { "id": "S-47", "title": "更改字段长度", "db": "MSSQL", "tags": "", "sql": "更改数据字段长度设置语句\n以下是一段自动生成变更字段长度或者类型的SQL语句的SQL脚本,通过运行以下语句,可以在输出窗口列出SQL语句,执行这些语句即可改变对应字段类型或者大小,并且在\"动态列设置\"表中增加好对应的记录.\n\n--查询需要变更的物料编码\nselect TB.name as TableName, TC.name as FieldName ,TC.Length,TC.IsNullable, \n TT.name as DataType,TD.Definition as [Default], TP.Value as Description\nfrom sys.tables TB left join sys.syscolumns TC on TB.object_id = TC.id\n left join sys.systypes TT on TT.XUserType = TC.XUserType\n left join sys.default_constraints TD on TC.cdefault = TD.object_id\n left join sys.extended_properties TP on TB.object_id = TP.major_id and TC.colid = TP.minor_id\nwhere (TC.name = 'ItmID' )\nOrder By TC.Length,TB.name\n--变更非主键字段(ItmID)\ndeclare @TableName nvarchar(20)\nset @TableName = ''\nwhile ( select Count(*)\n from sys.tables TB left join sys.syscolumns TC on TB.object_id = TC.id\n where TB.name > @TableName and TC.name = 'ItmID'\n and not exists(Select * from Information_Schema.Key_Column_Usage TK\n where TK.Table_Name = TB.name and TK.Column_Name = TC.name)) > 0\nBegin\nSelect Top 1 @TableName = TB.name \n from sys.tables TB left join sys.syscolumns TC on TB.object_id = TC.id\nwhere TB.name > @TableName and TC.name = 'ItmID'\n and not exists(Select * from Information_Schema.Key_Column_Usage TK\n where TK.Table_Name = TB.name and TK.Column_Name = TC.name)\n Order By TB.name\n print 'Alter Table ' + @TableName + ' Alter Column ItmID nvarchar(40)' \n print 'Insert into AATblDc \n(TableID,FieldName,OldFieldDbType,OldLength,OldNullable,OldDefaultValue,\nUseFieldDbType,UseLength,UseNullable,UseDefaultValue,\nNewFieldDbType,NewLength,NewNullable,NewDefaultValue)\nValues (''' + @TableName + ''', ''ItmID'', ''nvarchar'', 20, ''Y'', NULL, \n''Y'',''Y'',''N'',''N'',\n''nvarchar'', 40, ''Y'', NULL) ' \n\nend\n\n\n-- 接下来 BomID\\OriginItmID 也要改\n-- 再下来 手工改几个 ItmID 是主键的那几个表。\n MDItm\\MDItmAS\\MDItmAM\\MDLst\\MDLstP\\MDLstPA\\MDLstS\\MDLstSA\n BCStk\\BCIbr\\BCIbt\\BCIbtA)\n \t\n", "note": "", "created": "2026-09-18", "updated": "2026-09-18", "copies": 0 }, { "id": "S-48", "title": "自定义业务唯一标识号", "db": "MySQL", "tags": "", "sql": "StgGuid\n'101118' ObjType", "note": "", "created": "2026-09-18", "updated": "2026-09-18", "copies": 0 }, { "id": "S-49", "title": "查询自定义业务菜单", "db": "MySQL", "tags": "", "sql": "select * from AAMenuA where QueryID = '自定义业务标识'\nselect * from AAMenu where MenueID='从上一句得'", "note": "", "created": "2026-09-18", "updated": "2026-09-18", "copies": 0 }, { "id": "S-50", "title": "程序升级时对某文件夹访问权限被拒绝", "db": "MySQL", "tags": "", "sql": "ALTER DATABASE DEMO \nSET OFFLINE WITH ROLLBACK IMMEDIATE", "note": "", "created": "2026-09-18", "updated": "2026-09-18", "copies": 0 }, { "id": "S-51", "title": "各表单抛转分录金额", "db": "MySQL", "tags": "", "sql": "select TB.ObjType,TB.ObjName,\n sum(TD.Debit) as Debit,sum(TD.Credit) as Credit\n from GLVou TM\n left join GLVouA TD on TM.DocEntry=TD.DocEntry\n left join AAObj TB on TD.BaseType=TB.ObjType\n where TM.AbsID=@AbsID \n and TD.AccID in ('')\n group by TB.ObjType,TB.ObjName", "note": "", "created": "2026-09-18", "updated": "2026-09-18", "copies": 0 }, { "id": "S-52", "title": "总账领料金额", "db": "MySQL", "tags": "", "sql": "Select Sum(S.LLJE)\nfrom\n(select TD2.BaseEntry ,Sum(TD.Debit) LLJE,0 RK\nfrom GLVou TM\nleft join GLVouA TD on TD.DocEntry =TM.DocEntry \nleft join WHDrwA TD2 on TD2.ObjType=TD.BaseType and TD2.DocEntry =TD.BaseEntry and TD2.LineNum=TD.BaseLineNum \nwhere TM.AbsID='202210' and TD.AccID='500101' and TD.BaseType=135110\ngroup by TD2.BaseEntry \n\nunion all\nselect TD2.BaseEntry ,Sum(TD.Debit) LLJE,0RK \nfrom GLVou TM\nleft join GLVouA TD on TD.DocEntry =TM.DocEntry \nleft join WHBakA TD2 on TD2.ObjType=TD.BaseType and TD2.DocEntry =TD.BaseEntry and TD2.LineNum=TD.BaseLineNum \nwhere TM.AbsID='202210' and TD.AccID='500101' and TD.BaseType=135120\ngroup by TD2.BaseEntry)S", "note": "", "created": "2026-09-18", "updated": "2026-09-18", "copies": 0 }, { "id": "S-53", "title": "insert BOMA表", "db": "MSSQL", "tags": "", "sql": "insert into MDBomA (DocEntry,LineNum,ItmID,ItmName,ItmFName,ItmSpec,BarCodes,Serials,NumAtCrd,ItmTAName,ItmTBName,ItmTCName,\nItmTDName,ItmTEName,UomID,FixedQty,NetQty,ScrapRate,ScrapQty,RoundType,RoundScale,VndID,UseVndSet,ItmType,LineType,UseRpSet,FlushType,\nWhsID,OperationLine,Position,CostCompute,FreeTxt,Configurable,ConfigGroup,FormulaID,Length,Width,Height,LUomID,Factor1,Factor2,\nFactor3,Factor4,CostItmFactor,CostLaborFactor,CostManuFactor,IsWipMaterial,WUomID,NetWeight,GrssWeight,VUomID,NetVolumn,\nGrssVolumn,MetItmID,MetRou,MetQtyDesc,MetQtyRate,MetNetQty,MetRoundType,MetRoundScale,MetFactor1,MetFactor2,MetFactor3,\nMetFactor4,MetWUomID,MetNetWeight,MetGrssWeight,MetVUomID,MetNetVolumn,MetGrssVolumn,MetLength,MetWidth,MetHeight,MetLUomID,\nMetQty,MetCreQty,MetOpenQty,MetLineStatus,DrawNum,IBomID,IBomVerNum,IBaseEntry,IBaseLineNum,OrderNum,LineGuid,\n--以下为新字段\nLineStatus\n)\n\nselect \n DocEntry,LineNum,ItmID,ItmName,ItmFName,ItmSpec,BarCodes,Serials,NumAtCrd,ItmTAName,ItmTBName,ItmTCName,\nItmTDName,ItmTEName,UomID,FixedQty,NetQty,ScrapRate,ScrapQty,RoundType,RoundScale,VndID,UseVndSet,ItmType,LineType,UseRpSet,FlushType,\nWhsID,OperationLine,Position,CostCompute,FreeTxt,Configurable,ConfigGroup,FormulaID,Length,Width,Height,LUomID,Factor1,Factor2,\nFactor3,Factor4,CostItmFactor,CostLaborFactor,CostManuFactor,IsWipMaterial,WUomID,NetWeight,GrssWeight,VUomID,NetVolumn,\nGrssVolumn,MetItmID,MetRou,MetQtyDesc,MetQtyRate,MetNetQty,MetRoundType,MetRoundScale,MetFactor1,MetFactor2,MetFactor3,\nMetFactor4,MetWUomID,MetNetWeight,MetGrssWeight,MetVUomID,MetNetVolumn,MetGrssVolumn,MetLength,MetWidth,MetHeight,MetLUomID,\nMetQty,MetCreQty,MetOpenQty,MetLineStatus,DrawNum,IBomID,IBomVerNum,IBaseEntry,IBaseLineNum,OrderNum,LineGuid,'O'LineStatus\n--注意来源表名\nfrom YAERP.AERP_YA.dbo.MDBomA", "note": "", "created": "2026-09-18", "updated": "2026-09-18", "copies": 0 }, { "id": "S-54", "title": "insert BOMB表", "db": "MSSQL", "tags": "", "sql": "insert into MDBomB (DocEntry,LineNum,PrcID,PrcName,WcnID,WcnName,PreLineNum,Relation,Priority,DelayHour,BatchQty,WorkTime,\nWaitTime,\n\tTransTime,\n\tMaintenCount,\n\tIsMainten,\n\tPrice,\n\tFreeTxt,\n\tScrapRate,\n\tScrapQty,\n\tRoundType,\n\tRoundScale,\n\tFlushType,\n\tAutoCloseTolen,\n\tCloseTolenTop,\n\tCloseTolenBttm,\n\tCloseTolenExcept,\n\tModTypeID,\n\tWcnNum,\n\tWcnLoadPct,\n\tWrkPrice,\n\tSubPrice,\n\tCurrID,\n\tPrcUnit,\n\tQtyRate,\n\tProcPrice,\n\tCompPrice,\n\tModID,\n\tInstID,\n\tResGrpID,\n\tResGrpName,\n\tMaintenTime,\n\tMaxDelay,\n\tIsCycSBuff,\n\tIsCycEBuff,\n\tSBuffTime,\n\tEBuffTime,\n\tIsSchedule,\n\tSkipSign,\n--以下为新字段\t\n\tMacID,\n\tMacName,\n\tOpnCount,\n\tIsSup,\n\tSkipMes,\n\tHmiRate,\n\tPreHour1,\n\tPreHour2,\n\tAutoTransfer,\n\tAutoDispatch,\n\tIsOutSplit,\n\tIsPc,\n\tQtyTimes\n)\n\nselect \n \tDocEntry,LineNum,PrcID,PrcName,WcnID,WcnName,PreLineNum,Relation,Priority,DelayHour,BatchQty,WorkTime,\nWaitTime,\n\tTransTime,\n\tMaintenCount,\n\tIsMainten,\n\tPrice,\n\tFreeTxt,\n\tScrapRate,\n\tScrapQty,\n\tRoundType,\n\tRoundScale,\n\tFlushType,\n\tAutoCloseTolen,\n\tCloseTolenTop,\n\tCloseTolenBttm,\n\tCloseTolenExcept,\n\tModTypeID,\n\tWcnNum,\n\tWcnLoadPct,\n\tWrkPrice,\n\tSubPrice,\n\tCurrID,\n\tPrcUnit,\n\tQtyRate,\n\tProcPrice,\n\tCompPrice,\n\tModID,\n\tInstID,\n\tResGrpID,\n\tResGrpName,\n\tMaintenTime,\n\tMaxDelay,\n\tIsCycSBuff,\n\tIsCycEBuff,\n\tSBuffTime,\n\tEBuffTime,\n\tIsSchedule,\n\tSkipSign,\n\t\n\t''MacID,\n\t''MacName,\n\t0 OpnCount,\n\t'N'IsSup,\n\t'N'SkipMes,\n\t1 HmiRate,\n\t0 PreHour1,\n\t0 PreHour2,\n\t'N' AutoTransfer,\n\t'N' AutoDispatch,\n\t'N' IsOutSplit,\n\t'N' IsPc,\n\t1 QtyTimes\n\t\n--注意来源表名\nfrom YAERP.AERP_YA.dbo.MDBomB", "note": "", "created": "2026-09-18", "updated": "2026-09-18", "copies": 0 }, { "id": "S-55", "title": "insert BOMDf表", "db": "MSSQL", "tags": "", "sql": "insert into MDBomDF (BomID,BomName,ItmID,RouID,VerMode,VerNum,OpUserSign,OpUserName,OpDate,ChUserSign,ChUserName,\nChDate,ClDate,IsClose,PrjID,ProjectID\n)\n\nselect \nBomID,BomName,ItmID,RouID,VerMode,VerNum,OpUserSign,OpUserName,OpDate,ChUserSign,ChUserName,\nChDate,ClDate,IsClose,PrjID,ProjectID\n \t\n\t\n--注意来源表名\nfrom YAERP.AERP_YA.dbo.MDBomDF", "note": "", "created": "2026-09-18", "updated": "2026-09-18", "copies": 0 }, { "id": "S-56", "title": "insert BOM主表", "db": "MySQL", "tags": "", "sql": "insert into MDBom (DocEntry,BomID,BomName,ItmID,RouID,VerNum,Qty,ScrapRate,ScrapQty,Active,Approved,ApprovedBy,Attachment,\nDateTimeStamp,Remarks,LogInstanc,ObjType,OpUserSign,OpUserName,OpDate,ChUserSign,ChUserName,ChDate,ClDate,IsClose,PurviewID,\nIsBlock,DocStatus,DraftKey,ChartNumber,UseCondition,DefaultCondition,PrpID,MetRouID,BatchQty,WorkTime,AppDate,EncNum,EncObjType,\nApprovedA,ApprovedABy,AppDateA,ApprovedB,ApprovedBBy,AppDateB,IsMain,DesignEmpID,DesignEmpName,RoutingEmpID,RoutingEmpName,\n--以下为新增字段\nStatusNotes\n)\n\nselect \n DocEntry,BomID,BomName,ItmID,RouID,VerNum,Qty,ScrapRate,ScrapQty,Active,Approved,ApprovedBy,Attachment,\nDateTimeStamp,Remarks,LogInstanc,ObjType,OpUserSign,OpUserName,OpDate,ChUserSign,ChUserName,ChDate,ClDate,IsClose,PurviewID,\nIsBlock,DocStatus,DraftKey,ChartNumber,UseCondition,DefaultCondition,PrpID,MetRouID,BatchQty,WorkTime,AppDate,EncNum,EncObjType,\nApprovedA,ApprovedABy,AppDateA,ApprovedB,ApprovedBBy,AppDateB,IsMain,DesignEmpID,DesignEmpName,RoutingEmpID,RoutingEmpName,\n''StatusNotes\n--注意来源表名\nfrom YAERP.AERP_YA.dbo.MDBom", "note": "", "created": "2026-09-18", "updated": "2026-09-18", "copies": 0 }, { "id": "S-57", "title": "insert 物料", "db": "MSSQL", "tags": "", "sql": "--注意自定义字段！！！！\n\ninsert into MDItm (\nItmID,ItmName,ItmFName,ItmSpec,IsUseBaseUom,UomGrpID,BaseUomID,ItmKindID,BarCodes,Serials,ItmTmpltID,ItmGrpID,CstGrpID,\nTaxGrpID,WhsGrpID,DimTypeAID,DimTypeBID,CostPrice,ItmTAID,ItmTBID,ItmTCID,ItmTDID,ItmTEID,SourceID,ListID,Remarks,Picture,\nPictureName,GLMethod,ByWh,IsAssetItm,IsInvntItm,AbcGrpID,IsCycleCount,CountTolenTop,CountTolenBttm,IsChkShrtg,MaxStock,\nMinStock,IsCtrlLot,IsCtrlLife,LifeDays,IsSplitLot,IsMergeLot,IsReservable,LotNumPrefix,LotNumStart,IsCtrlSerial,SerialNumPrefix,\nSerialNumStart,IsCtrlLcn,IsLimitLcn,LcnID,IsLimitWhs,WhsID,IsPurItm,PurUomID,IsFixPurRate,PurCvtRate,PurFactor1,PurFactor2,\nPurFactor3,PurFactor4,PurFormula,IsFixedVendor,DefVndID,DefPurEmpID,PurTaxID,PurTaxRate,RevCloseTolen,InvCloseTolen,PurPriceTolen,\nPurPriceTolenTop,PurPriceTolenBttm,PurPriceTolenExcept,RevTolenTop,RevTolenBttm,RevTolenExcept,RevLateDays,IsPartRev,RevRouting,\nIsSaleItm,SaleUomID,IsFixSaleRate,SaleCvtRate,SaleFactor1,SaleFactor2,SaleFactor3,SaleFactor4,SaleFormula,SaleTolenTop,SaleTolenBttm,\nSaleTolenExcept,SaleTaxID,SaleTaxRate,SalePriceTolen,SalePriceTolenTop,SalePriceTolenBttm,SalePriceTolenExcept,SaleCloseTolen,\nATPFormula,IsChkATP,ATPExcept,IsReturn,IsRMAQC,CommisnID,CommisnRate,SpcialDisc,WUomID,NetWeight,GrssWeight,VUomID,NetVolumn,\nGrssVolumn,Length,Width,Height,LUomID,IsCtrlValid,ValidFr,ValidTo,ValidComm,IsCtrlFrozen,FrozenFr,FrozenTo,FrozenComm,LogInstanc,\nObjType,DocEntry,IsPubWeb,UNNum,HazardClass,OpUserSign,OpUserName,OpDate,ChUserSign,ChUserName,ChDate,ClDate,IsClose,OwnerID,\nOwnerName,PurviewID,DraftKey,WddStatus,IsBlock,Template,DocStatus,PriceMode,UseDim,DimGroup,MaskofBatchNum,MaskofSerialNum,\nAttachment,FormulaID,Formula,DimAKind,DimBKind,FixedDimKind,IsOfficeItm,IsVndItm,\n--以下为75系统物料新增字段和自定义字段\nIsMain,DimBatchQty,DocKind,UseDimDate,ExCmd1,\nExCmd2,CltID,PartID,PN,SN,Locked,LockUserSign,LockUserName,LockDate,LockNotes,\n--Z_YXQTS,Z_DM,Z_MinSize,Z_XJ\n )\n\nselect \nItmID,ItmName,ItmFName,ItmSpec,IsUseBaseUom,UomGrpID,BaseUomID,ItmKindID,BarCodes,Serials,ItmTmpltID,ItmGrpID,CstGrpID,\nTaxGrpID,WhsGrpID,DimTypeAID,DimTypeBID,CostPrice,ItmTAID,ItmTBID,ItmTCID,ItmTDID,ItmTEID,SourceID,ListID,Remarks,Picture,\nPictureName,GLMethod,ByWh,IsAssetItm,IsInvntItm,AbcGrpID,IsCycleCount,CountTolenTop,CountTolenBttm,IsChkShrtg,MaxStock,\nMinStock,IsCtrlLot,IsCtrlLife,LifeDays,IsSplitLot,IsMergeLot,IsReservable,LotNumPrefix,LotNumStart,IsCtrlSerial,SerialNumPrefix,\nSerialNumStart,IsCtrlLcn,IsLimitLcn,LcnID,IsLimitWhs,WhsID,IsPurItm,PurUomID,IsFixPurRate,PurCvtRate,PurFactor1,PurFactor2,\nPurFactor3,PurFactor4,PurFormula,IsFixedVendor,DefVndID,DefPurEmpID,PurTaxID,PurTaxRate,RevCloseTolen,InvCloseTolen,PurPriceTolen,\nPurPriceTolenTop,PurPriceTolenBttm,PurPriceTolenExcept,RevTolenTop,RevTolenBttm,RevTolenExcept,RevLateDays,IsPartRev,RevRouting,\nIsSaleItm,SaleUomID,IsFixSaleRate,SaleCvtRate,SaleFactor1,SaleFactor2,SaleFactor3,SaleFactor4,SaleFormula,SaleTolenTop,SaleTolenBttm,\nSaleTolenExcept,SaleTaxID,SaleTaxRate,SalePriceTolen,SalePriceTolenTop,SalePriceTolenBttm,SalePriceTolenExcept,SaleCloseTolen,\nATPFormula,IsChkATP,ATPExcept,IsReturn,IsRMAQC,CommisnID,CommisnRate,SpcialDisc,WUomID,NetWeight,GrssWeight,VUomID,NetVolumn,\nGrssVolumn,Length,Width,Height,LUomID,IsCtrlValid,ValidFr,ValidTo,ValidComm,IsCtrlFrozen,FrozenFr,FrozenTo,FrozenComm,LogInstanc,\nObjType,DocEntry,IsPubWeb,UNNum,HazardClass,OpUserSign,OpUserName,OpDate,ChUserSign,ChUserName,ChDate,ClDate,IsClose,OwnerID,\nOwnerName,PurviewID,DraftKey,WddStatus,IsBlock,Template,DocStatus,PriceMode,UseDim,DimGroup,MaskofBatchNum,MaskofSerialNum,\nAttachment,FormulaID,Formula,DimAKind,DimBKind,FixedDimKind,IsOfficeItm,IsVndItm,\n'' IsMain,'100' DimBatchQty,'0' DocKind,'' UseDimDate,''ExCmd1,\n'' ExCmd2,'' CltID,'' PartID,'' PN,'' SN,'' Locked,'' LockUserSign,\n'' LockUserName,'' LockDate,'' LockNotes,\n--0 Z_YXQTS,'' Z_DM,1 Z_MinSize,'' Z_XJ\n\nfrom YAERP.AERP_YA.dbo.MDItm", "note": "", "created": "2026-09-18", "updated": "2026-09-18", "copies": 0 }, { "id": "S-58", "title": "批量变更字段长度", "db": "MSSQL", "tags": "", "sql": "1.查出涉及到该字段的表\nselect TB.name as TableName, TC.name as FieldName ,TC.Length,TC.IsNullable, \n TT.name as DataType,TD.Definition as [Default], TP.Value as Description\nfrom sys.tables TB left join sys.syscolumns TC on TB.object_id = TC.id\n left join sys.systypes TT on TT.XUserType = TC.XUserType\n left join sys.default_constraints TD on TC.cdefault = TD.object_id\n left join sys.extended_properties TP on TB.object_id = TP.major_id and TC.colid = TP.minor_id\nwhere (TC.name = 'AstID' )\nOrder By TC.Length,TB.name\n2.新建表AAALK，字段为ObjName，将查出的表名贴进去\n3.使用查询语句把把修改字段长度Insert 到更改字段属性表(AATblDc)里（我是把固资编码字段修改到200），附上语句。\ninsert into AATblDc \n\nselect TABLE_NAME TableID,'AstID' as FieldName,'nvarchar' OldFieldDbType,CHARACTER_MAXIMUM_LENGTH as OldLength,'Y' as OldNullable,null OldDefaultValue,\n\n'N' UseFieldDbType,'Y' AS UseLength,'N' UseNullable,'N'UseDefaultValue,'nvarchar' NewFieldDbType ,200 as NewLength,'N' NewNullable,null NewDefaultValue\n\n from information_schema.columns t\n\n LEFT JOIN AAALK S ON T.TABLE_NAME =S.ObjName\n\n where T.COLUMN_NAME = 'AstID' AND S.ObjName IS NOT NULL\n4.再把数据库中的字段长度修改下,语句如下。把查询的结果直接复制到数据库中执行以下。再重启一下服务，大功告成！\n\nselect 'alter' + ' ' + 'TABLE ' + ObjName + ' ' + 'ALTER COLUMN AstID nvarchar (200)' \n\n from AAALK", "note": "", "created": "2026-09-18", "updated": "2026-09-18", "copies": 0 } ], "gallery": [ { "id": "A-001", "name": "看板", "created": "2026-09-18", "images": [] }, { "id": "A-002", "name": "大数据中心", "created": "2026-09-18", "images": [] }, { "id": "A-003", "name": "仪表板", "created": "2026-09-18", "images": [] }, { "id": "A-004", "name": "现场数据展示", "created": "2026-09-18", "images": [ { "id": "G-0001", "name": "看板示例", "src": "/gallery/A-004_G-0001.jpg", "w": 1600, "h": 1200, "added": "2026-09-18", "size": 202921 }, { "id": "G-0002", "name": "image.png", "src": "/gallery/A-004_G-0002.jpg", "w": 1491, "h": 819, "added": "2026-09-18", "size": 80446 } ] }, { "id": "A-005", "name": "实施现场素材", "created": "2026-09-18", "images": [] }, { "id": "A-006", "name": "典型资源素材", "created": "2026-09-18", "images": [ { "id": "G-0003", "name": "image.png", "src": "/gallery/A-006_G-0003.jpg", "w": 1600, "h": 723, "added": "2026-09-18", "size": 163643 } ] }, { "id": "A-007", "name": "标签", "created": "2026-09-18", "images": [] }, { "id": "A-008", "name": "站点安装", "created": "2026-09-18", "images": [] }, { "id": "A-009", "name": "视频素材库", "created": "2026-09-20", "images": [] } ], "ui": { "title": "李锴的个人工作台", "logo": "LK", "hidden": [], "deleted": [] }, "catsInit": true } }