DES Encryption/Decryption Function

There is a great article on SQLServerCentral on an Extended Stored Procedure http://www.sqlservercentral.com/columnists/mcoles/freeencryption.asp and this XP will undoubtedly perform better than my Function. However I had a need to encrypt a column in a shared hosted environment where I was not allowed to install XPs. Just copy script and paste into Query Analyzer

2007-06-26 (first published: )

707 reads

Blogs

Microsoft Tools That Help Query Tuning

By

Query tuning is not easy. In fact, for a lot of people, you shouldn’t...

Author of the Year 2019 Nomination at MSSQLTips

By

This year I’ve been nominated again for the Author of the Year award at...

Extended Events Misperceptions: Profiler is Easier

By

I know, I know, I’m on #teamexevents so I think that Extended Events can...

Read the latest Blogs

Forums

Slimymed

By ouhgqabhugop

https takeapills com/slimymed-de/  

Update 22/01/2020 - ICQ678924920 => Sell Credit Card/DeadFullz/Gifts Card

By jack678924920

Hi guys! Call me Jack.. Update 22/01/2020 12:04 PM LIST CREDIT CARD AND GIFT...

how to create query based on optional field on temp table ?

By ahmed_elbarbary.2010

problem how to create query based on optional field on temp table ? I...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers