KSOA单据保护表中Clientid解析为mac和ip
摘要：
SELECT DISTINCT a.*,ISNULL(c.client_net_address,'') AS client_net_address FROM ( SELECT * ,RIGHT(UPPER(sys.fn_varbintohexstr(CONVERT(VARBINARY(4),CAST(SUBSTRING(clientid,1,3) AS INT... 阅读全文
posted @ 2019-02-15 10:45 癫狂编程 阅读(413) 评论(0) 推荐(0)
浙公网安备 33010602011771号