如何使用Sql Server命令? [英] How to Sql Server Command?

问题描述

我想更改2个字母并掩盖其余字母.我更改了字母，但没有遮盖其他字母.该更改命令是

I want to change 2 letters and mask the remaining letters. I changed the letters but didn't mask other letter. This change command is

SELECT NAME,
       CONCAT(SUBSTRING(NAME, 1, 2), 
              SUBSTRING(NAME, 4, 1), 
              SUBSTRING(NAME, 3, 1), 
              SUBSTRING(NAME, 5, ABS(LEN(NAME) -4))) 
       AS CHANGELETTER
FROM TESTBILGILER

如何屏蔽SQL SERVER 2014?

How can I do masking SQL SERVER 2014?

推荐答案

有点丑陋，但这是另一个选择

A little ugly, but here is another option

示例

Declare @YourTable table(SomeCol varchar(50))
Insert Into @YourTable values
 ('Chirstina')
,('John')
,('Susan')
,('Wil')      -- May want to wrap in a case for smaller strings
,('Bo')       -- May want to wrap in a case for smaller strings


Select Masked = replicate('X',((len(SomeCol)-2)/2))
               +substring(SomeCol,((len(SomeCol)-2)/2)+1,2)
               +replicate('X',len(SomeCol)-((len(SomeCol)-2)/2)-2)
 From @YourTable

返回

Masked
XXXrsXXXX
XohX
XusXX
WiX
Bo

这篇关于如何使用Sql Server命令?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！