reate function 加密(@In Varchar(8000))
returns varchar(8000)
As
begin
declare @out varchar(8000),@i int,@j int
select @Out='',@i=1
while @i <= len(Rtrim(@In))
Begin
Set @j = UNICODE(SubString(@In,@i,1))+19
Set @Out=@Out+nChar(@j)
Set @i=@i+1
End
return @out
end
go
create function 解密(@In Varchar(8000))
returns varchar(8000)
As
begin
declare @out varchar(8000),@i int,@j int
select @Out='',@i=1
while @i <= len(Rtrim(@In))
Begin
Set @j = UNICODE(SubString(@In,@i,1))-19
Set @Out=@Out+nChar(@j)
Set @i=@i+1
End
return @out
end
go
select
returns varchar(8000)
As
begin
declare @out varchar(8000),@i int,@j int
select @Out='',@i=1
while @i <= len(Rtrim(@In))
Begin
Set @j = UNICODE(SubString(@In,@i,1))+19
Set @Out=@Out+nChar(@j)
Set @i=@i+1
End
return @out
end
go
create function 解密(@In Varchar(8000))
returns varchar(8000)
As
begin
declare @out varchar(8000),@i int,@j int
select @Out='',@i=1
while @i <= len(Rtrim(@In))
Begin
Set @j = UNICODE(SubString(@In,@i,1))-19
Set @Out=@Out+nChar(@j)
Set @i=@i+1
End
return @out
end
go
select
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货