Mask column value in SQL Server using Replicate function

sds

SOLVED CLOSED ACTIVE ANSWERED
User: sds
Posted: on Feb 13, 2022 10:07 PM
Forum: SQL Server
Answer: 1
Views: 1845

How can i script to mask name and NRIC of the Rolelist table into Rolelistmasked table.

Below are the columns (Name, NRIC, Address)

I need to mask

CREATE TABLE [dbo].[Rolelist]
(
    [Role_List_ID] [int] IDENTITY(1,1) NOT NULL,
    [Name] [varchar](100) NOT NULL,
    [NRIC] [int] NOT NULL,
    [Address] [varchar](100) NOT NULL,
)

After masking, i need to back up all the tables in the database except the Rolelist table.

For this do in need to create script for each table separately?

Thanks

Download FREE API for Word, Excel and PDF in ASP.Net

dharmend...

0 3

Reply
ANSWER
User: dharmendr
Replied: on Feb 14, 2022 04:46 AM
Report

Hi sds,

Use REPLICATE function and specify the replace character with Length.

Refer below query.

SQL

DECLARE @Rolelist AS TABLE
(
    [NRIC] [int] NOT NULL
)
INSERT INTO @Rolelist VALUES (123)
INSERT INTO @Rolelist VALUES (4568)

SELECT REPLICATE('X', LEN(NRIC)) [NRIC] FROM @Rolelist

Output

NRIC

XXX

XXXX

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Mask column value in SQL Server using Replicate function

Company

Explore

Follow us

Contact Us