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 = ascii(SubString(@In,@i,1))+19
Set @Out=@Out+Char(@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 = ascii(SubString(@In,@i,1))-19
Set @Out=@Out+Char(@j)
Set @i=@i+1
End
return @out
end
go
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 = ascii(SubString(@In,@i,1))+19
Set @Out=@Out+Char(@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 = ascii(SubString(@In,@i,1))-19
Set @Out=@Out+Char(@j)
Set @i=@i+1
End
return @out
end
go
创建一个函数这样就可以了对吧,我去试试,先谢谢了
我执行了你的 T-SQL 语句,怎么我去查看数据库的时候还是可以看得到数据呢???
求助