Technical Article

Encryption Example

,

Here in this T-sql tip I'am trying to compare the word "Hijacker" with two cases(line 3 and 4). Now they are in same when you compare the case (letter to letter), now you change the case of word "Hijacker" in either of the lines and run this SQL statements it will return different results. This kind of comparision can be used in case if your server is set for case insensitiveness. And also this kind of statements can be used to encrypt the password for client server applications etc..I have line number for the convience of explanation

1: DECLARE @gg VARCHAR(100)
2: DECLARE @AA VARCHAR(100)
3: select @gg = ( select encrypt('Hijacker') )
4: select @AA = ( select encrypt('Hijacker') )
5if @gg=@AA 
6print @gg+" ---- They are Same -------"+@AA
7if @gg<>@AA
8print @gg+" ---- Not Matching  -------"+@AA

Rate

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

Share

Join the discussion and add your comment

Share

Rate

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

Related content

SQLServerCentral Article

A Normalization Primer

For most DBAs, normalization is an understood concept, a bread and butter bit of knowledge. However, it is not at all unusual to review a database design by a development group for an OLTP (OnLine Transaction Processing) environment and find that the schema chosen is anything but properly normalized. This article by Brian Kelley will give you the core knowledge to data model.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

5 (3)

You rated this post out of 5. Change rating

2003-01-13

18,497 reads