sqlserver存储过程加密和解密

★ 加密存储过程 ★：

IF EXISTS (SELECT name FROM sysobjects WHERE name = 'encrypt_this' AND type = 'P')   
DROP PROCEDURE encrypt_this 
GO 
USE pubs 
GO 
CREATE PROCEDURE encrypt_this 
WITH ENCRYPTION  ---添加WITH ENCRYPTION即可 AS 
SELECT * FROM authors
GO  
--查看存储过程文本： 
EXEC sp_helptext encrypt_this 
--下面是结果集： 
--***The object's comments have been encrypted.  
------对象已经被加密 

★ 解密存储过程 ★： 
 
***CREATE  PROCEDURE sp_decrypt(@objectName varchar(50))
AS
begin   
set nocount on 
begin tran   
declare @objectname1 varchar(100),@orgvarbin varbinary(8000) 
declare @sql1 nvarchar(4000),@sql2 varchar(8000),@sql3 nvarchar(4000),@sql4 nvarchar(4000)   
DECLARE  @OrigSpText1 nvarchar(4000),@OrigSpText2 nvarchar(4000) , @OrigSpText3 nvarchar(4000), @resultsp nvarchar(4000)   
declare  @i int,@status int,@type varchar(10),@parentid int   
declare @colid int,@n int,@q int,@j int,@k int,@encrypted int,@number int  
select @type=xtype,@parentid=parent_obj from sysobjects where id=object_id(@ObjectName)      
create table  #temp(number int,colid int,ctext varbinary(8000),encrypted int,status int)   
insert #temp SELECT number,colid,ctext,encrypted,status FROM syscomments  WHERE id = object_id(@objectName)   
select @number=max(number) from #temp   set @k=0      
while @k<=@number    begin   
if exists(select 1 from syscomments where id=object_id(@objectname) and number=@k)   
begin   
if @type='P'