SQL script to iterativity change some field values
$10-30 USD
Paid on delivery
Hello SQL expert,
I want to obscurate some fields in the table of my MS-SQL database.
Feilds such as name/emailid/ip_address, I want to replace with random ascii value.
How to iterativity change name/emailid/ip_address with obscurated value?
My table design looks like the following.
username varchar(50)
password varchar(50)
emailid nvarchar(100)
code varchar(50)
ip_address char(20)
joinedon datetime
sex char(1)
bday date
coupon int
I need script which can run in Server Managment Studio. Something close in internet what I could find is the following. But it dont have any sort of obscuration.
Can you write script and test and deliver the code to me?
[login to view URL]
select top 1000 TableID
into #ControlTable
from [login to view URL]
where StatusID = 7
declare @TableID int
while exists (select * from #ControlTable)
begin
select top 1 @TableID = TableID
from #ControlTable
order by TableID asc
-- Do something with your TableID
delete #ControlTable
where TableID = @TableID
end
drop table #ControlTable
Project ID: #12279732
About the project
Awarded to:
It is simple for me.I can implement a DB function that dcontains a cursor and a loop for the rows of cursor and randomly ascii code will be inserted to filed value.
Please review my profile. https://www.freelancer.com/u/vw7590795vw.html I have 7 years experience in SQL Server. Please let me know more details and when will we start. Skype: jikenjd
14 freelancers are bidding on average $31 for this job
Hey, How are you .. I can do any script in sql server but can you explain obscuration in more detail. thanks
Hi, I have 5+ years of object-oriented architecture designing, programming and administration experience with success devising software solutions to meet business requirements. - Full-stack developer with C#.NET, Ion More
Hello SQL Server expert searcher! I would like to help you with the creation of an Sql stored procedure that you can execute and process the data by replacing it with random string! i already have and use SQL Serve More