:::tip{title="提示"}
新所有明细里没有导购编号的记录

:::



![image.png](/static/img/62a8c2326be8ec91f5b47a9406da3c11.image.webp)

```
UPDATE dtl
SET 
    dtl.salesmanid = (
        SELECT STUFF((
            SELECT ',' + m.emp_id
            FROM BAS_EMP m
            WHERE CHARINDEX(m.emp_name, dtl.salesman) > 0
              AND m.shp_id = gtss.shp_id 
            FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 1, '')
    )
FROM 
    dat_gtss_dtl dtl
JOIN 
    dat_gtss gtss ON dtl.id = gtss.id
WHERE 
    gtss.sys_netdate > '2025-1-1'  -- 仅更新 sys_netdate > '2025-1-1' 的记录
    AND dtl.salesman IS NOT NULL  
    AND dtl.salesman <> ''       
    AND (dtl.salesmanid IS NULL OR dtl.salesmanid = '');  




```

新所有明细里没有导购编号的记录

:::tip{title="提示"}
列名'客户昵称' 无效。

:::



![](https://school.hansonvip.com/static/img/8b21cb851919a675afcf03fcc0ade9d7.1751967216240.webp)


```

---20201010新VIP卡种类对应查询试图ESM_BAS_VIP_V1New
 if exists(select 1 from sysobjects where id=OBJECT_ID('ESM_BAS_VIP_V1New') and type='V')
 drop view ESM_BAS_VIP_V1New
 GO

CREATE VIEW [dbo].[ESM_BAS_VIP_V1New]
AS
SELECT     vip.id AS 自动编号, vip.vip_id AS 贵宾卡号, kind.VIP_KIND AS 卡种类, vip.vip_name AS 客户姓名,  vip.Vip_Realname as 客户昵称, 
                      CAST(CASE vip.vip_sex WHEN 1 THEN '男' WHEN 0 THEN '女' ELSE '' END AS char(2)) AS 性别, vip.vip_MyId AS 身份证号, vip.vip_reg_date AS 入会时间, 
                      vip.vip_birthday AS 生日, vip.vip_mobil_phone AS 手机, vip.vip_case AS 发卡原因, vip.shp_Id AS 发卡店, vip.vip_bus_tele AS 商务电话, vip.vip_email AS 电子邮件, 
                      vip.vip_bp AS 呼机, vip.vip_add AS 地址, vip.vip_tele AS 电话, vip.vip_type AS 种类, vip.vip_pwd AS 密码, vip.vip_work AS 职业, vip.vip_discount AS 折扣率, 
                      vip.vip_reDiscount AS 允许折上折, vip.vip_upMoney AS 折上折限额, vip.sys_valid AS 状态, vip.sys_memo AS 备注, vip.sys_date AS 日期, vip.VIP_QQ AS QQ, 
                      vip.VIP_microblogging AS 博客, vip.VIP_microchannel AS 微信, DATEPART(year, vip.vip_birthday) AS 生日_年, DATEPART(month, vip.vip_birthday) AS 生日_月, 
                      DATEPART(day, vip.vip_birthday) AS 生日_日
FROM         dbo.BAS_VIP AS vip LEFT OUTER JOIN
                      dbo.BAS_VIP_KINDNew AS kind ON vip.VIP_KIND = kind.VIP_ID
GO


```

列名'客户昵称' 无效。

:::tip{title="提示"}
条码/吊牌打印模板更改打印？

:::


回答：打开模板---点打印------选择打印机名称-----保存模板即可
![8aab0d5bda9ebdc6aac984e7eca237b.png](/static/img/f20f6b5f16c3db308922f9f6e63a67fe.image.webp)

打印模板更改打印

登录系统：列名 'sys chk' 无效

:::tip{title="提示"}
tcping 用法
:::



参考连接：https://cloud.tencent.com/developer/article/2102168
。   

一、概述
ping程序发送icmp包，用于检测网络连通性，如果主机禁ping，就没办法判断连通性了。
 tcping程序基于tcp协议，查看网络延迟及开放的端口信息。
 
![image.png](/static/img/843dd80dbbd29c112fc7d751b9963c23.image.webp)

二、软件安装
1、下载tcping工具（根据自身系统选择32位/64位） https://elifulkerson.com/projects/tcping.php

tcping程序有很多不同的贡献者，此处下载的是 Eli Fulkerson开发的tcping


![image.png](/static/img/96b671a02c7e12474b10ce4ce2288857.image.webp)

2、安装tcping
 将下载的exe文件放到 c:\windows\system32\ 目录下面（如果下载的是64位的要把文件名改为tcping.exe 反之使用的时候要输入 tcping64 ）
 
 
![image.png](/static/img/be903946a674aa6531ef2b7006ed4558.image.webp)

3、使用tcping
 cmd打开命令提示符，输入tcping 如果出现帮助文档说明安装命令成功
 
 
![image.png](/static/img/1810bf967dd970a0b63bee17d966822b.image.webp)

![image.png](/static/img/8429aec1b9e186b6211b42a52f10cd23.image.webp)

![image.png](/static/img/1284a0ed133422b30399f0d6c9a7031c.image.webp)


![image.png](/static/img/6533592903b26574321cedfafd026c71.image.webp)

二、参考资料
1、tcping端口检测工具使用 – 码迷  http://www.mamicode.com/info-detail-2699390.html
 2、tcping.exe – ping over a tcp connectiong