Find Jobs
Hire Freelancers

SQL Server Stored Proceddure to ASCII Encrypt and Decrypt string

$30-250 USD

Completed
Posted over 9 years ago

$30-250 USD

Paid on delivery
Take exiting VB function that ASCII encrypts and decrypts a string and create a SQL Server stored procedure to do the same. Stored Procedure would accept two parameters and return a string. Parameters: strIn - String to encrypt or decrypt. Could be a table field string as parameter too strPassword - Password used to encrypt or decrypt strIn string Returns: strOut - Encrypted or decrypted string Sample VB code is attached. The solution should be self contained within a stored proceedure, and usable from within SQL Management Studio. Need to work with SQL 2005 Express and later versions of SQL Server. (2008, 2008 R2, 2012). The solution must be fully comparable with the VB code listed here, so that a string encrypted with the VB code could be decrypted with the stored procedure (and vice versa).
Project ID: 7098311

About the project

23 proposals
Remote project
Active 9 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hi I have been working with MSSQL for over 14 years. I am fully experienced as a developer and a DBA. Currently I am working at big financial organization in which I am responsible for the BI department. I have designed and the Developed the Organization’s Reporting Database which has been constructed with SQL Server 2008 R2 Enterprise Edition. The database is being updated daily from the core system with txt or excel files via SSIS or with direct connection at mainframe’s DB2 and a numerous of KPIS are being daily updated during the ETL. For isolation reasons the KPIS are replicated to another DB (with transactional replication) which exploits the reports via SSRS to the consumers. Some KPIS are being replicated with merged (bidirectional) replication. Also, 10 Cubes in SSAS are being daily automatically processed and the end of the ETL. Several other reports are daily automatically produced and sent via email to the recipients. Finally I have designed and developed the bank’s crm DB which is published on the intranet. The DB holds full information about the customers (Customers,Addresses , Financial Data , Contacts , campaigns , etc) and covers 4 countries. To achieve this i have made partitions over the country code. The size of the Reporting DB, is about 4TB and consists of about 4.000 objects and the replicated KPI DB is 350GB. Best Regards mpalgeo
$77 USD in 3 days
5.0 (76 reviews)
6.3
6.3
23 freelancers are bidding on average $146 USD for this job
User Avatar
Hello, My name is Janos and I'd like to help you on this! The requirement seems fairly straightforward, after looking at what's needed I don't really have any questions at this point and should be able to deliver this fully tested in a ready-to-deploy-and-use form, as a SQL script, within a few days. The stored procedure will have proper commenting to explain what's being done and will work on SQL 2005 and above. Also I'll be available for future support/development at any point in time, as you may require. I look forward to working with you! thanks & regards, Janos
$250 USD in 5 days
5.0 (18 reviews)
6.7
6.7
User Avatar
Hi ready to start. Thanks ................................................................................................
$155 USD in 3 days
5.0 (110 reviews)
6.2
6.2
User Avatar
A proposal has not yet been provided
$250 USD in 5 days
5.0 (5 reviews)
4.7
4.7
User Avatar
right up my alley, I've done sqlserver stored procedures for more than ten years now and this seems to be a nice project to work on
$200 USD in 1 day
5.0 (13 reviews)
4.6
4.6
User Avatar
A proposal has not yet been provided
$150 USD in 1 day
5.0 (5 reviews)
4.1
4.1
User Avatar
Hi, I have gone through your descriptions, I am 8+ years experienced Visual Basic,HTML,CSS,VB.NET,ASP.NET,MVC,C#,Bootsrap,Telerik control,Crystal report,MS Access,MySQL,SQL,MSSQL Server(2005 to On wards) developer at CMMI-5 level company.I can do your work confidently. I am very much Interested to do your work,Please revert me if you have any concern..
$240 USD in 5 days
3.9 (27 reviews)
5.4
5.4
User Avatar
Hi, I'm high rated coder from Ukraine with a more than 12 years strong experiences in MS SQL Server (7, 9, 11). Thanks, Andriy
$50 USD in 3 days
5.0 (14 reviews)
3.4
3.4
User Avatar
I can help you paddingpaddingpaddingpaddingpaddingpaddingpaddingpaddingpaddingpaddingpaddingpadding
$66 USD in 1 day
5.0 (1 review)
3.0
3.0
User Avatar
I have already implemented the SQLScript for your requirement. Please ping me if you would like to see the script. My gmailid is umesh532@gmail dot com,in case I am not online on Freelancer. I have around 8 years of experience on SQLServer and Sure you would be happy with the Code quality.
$111 USD in 1 day
5.0 (1 review)
2.6
2.6
User Avatar
A proposal has not yet been provided
$283 USD in 3 days
5.0 (1 review)
2.4
2.4
User Avatar
Over 14 years of experience in Microsoft Technologies. MCTS (Microsoft Certified Technology Specialist) on Web Applications Development with Microsoft .NET Framework 4 (Exam Code: 070-515). Functional experience includes Telecom Application (OSS & BSS Rating and Billing), Financial Application, ERP-Application, and School Application, Central and State Govt. Offices application and development of user interface elements for embedded software. Having good knowledge and skills in OOPS (Object Oriented Programming), ASP.net with C# & VB, Web services (SOAP, WSDL), WCF, MVC, Entity Framework, Visual Basic, Crystal Report, MS SQL Server, Oracle and MS Access. Experience in working VS2012, VS2013 and VS2014 with AngularJS, Knockoutjs, DurandalJS, KendoUI etc all advanced technologies. I have a ready made code for it and can quickly deliver with few tweaks only. Very committed to deliver products matching with requirements on or before time. I will develop and give demonstration frequently to match your expectations. For any clarifications, contact me.
$55 USD in 1 day
4.4 (2 reviews)
2.2
2.2
User Avatar
Dear Sir. We claim to get it done perfectly for you EXACTLY in the way you want it - Kindly give we a chance and we will prove myself - Ready to prove our words, let's get it done right away and I mean RIGHT AWAY !! Looking forward to hear from you soon - GOD Bless You.
$178 USD in 3 days
5.0 (1 review)
1.0
1.0
User Avatar
Software developer since 2000, specializing in Visual Basic, SQL Server, Crystal Reports, and VBA for MS Office.
$50 USD in 1 day
5.0 (1 review)
0.7
0.7
User Avatar
A proposal has not yet been provided
$277 USD in 1 day
0.0 (1 review)
0.0
0.0
User Avatar
I developed Desktop Application in Network Security, which takes Message String and Encryption Code and apply using Different Algorithm (public and private key both).
$166 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$88 USD in 0 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I have extensive SQL development experience as well as experience with VB.NET. I will be able to quickly turnaround this translation for you.
$111 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$55 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have excellent exposure to SQL Server working for Clients like Fidelity Investemenst, Citibank etc.., I am really excited to be involved in your project. Thanks Deepak
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$122 USD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Greensboro, United States
5.0
22
Payment method verified
Member since Jul 22, 2007

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.