sql ¼ÓÃÜ

use Tempdb
go
if object_ID ( 'fn_ACITEncryption' ) is not null
drop function fn_ACITEncryption
go
create function fn_ACITEncryption
(
@Str nvarchar ( 4000), -- ¼ÓÃܵÄ×Ö·û´®
@Flag bit = 1, --1 ¡¢¼ÓÃÜ 0 ¡¢½âÃÜ
@Key nvarchar ( 50) -- ÃÜÎÄ
)
returns nvarchar ( 4000) -- 這Àï¿É轉換³É¶þ進ÖÆ
with Encryption
as
begin
Declare @LenStr int , @i int , @Str2 nvarchar ( 4000), @Split nvarchar ( 2), @LenKey int
select @Str= @Str+ 'A' , @LenStr= len ( @Str), @i= 1, @Str2= '' , @LenKey= Len ( @Key+ 'A' )- 1
while @i< @LenStr
select @Split= substring ( @Str, @i, 1),
@Split= nchar (( unicode ( @Split)+ case @Flag when 1 then unicode ( substring ( @Key+ 'A' , @i% @LenKey+ 1, 1))- 1
when 0 then 65535- unicode ( substring ( @Key+ 'A' , @i% @LenKey+ 1, 1))
else 0 end )% 65535+ cast ( @Flag as int )),
@Str2= @Str2+ @Split, @i= @i+ 1
return @Str2

end
go
select dbo. fn_ACITEncryption( N'Roy' , 1, '123' ) as ¼ÓÃܺó×Ö·û´®

/*
¼ÓÃܺó×Ö·û´®
------------------------------
(1 個資ÁÏÁÐÊܵ½Ó°響 )

*/
select dbo. fn_ACITEncryption( N, 0, '123' ) as ½âÃܺó×Ö·û´®
/*
½âÃܺó×Ö·û´®
--------------------------
Roy

(1 個資ÁÏÁÐÊܵ½Ó°響 )
*/
±¾ÎÄÀ´×ÔCSDN²©¿Í£¬×ªÔØÇë±êÃ÷³ö´¦£ºhttp://blog.csdn.net/roy_88/archive/2009/11/12/4801917.aspx