½âÃÜSQL SERVER 2005¼ÓÃÜ´æ´¢¹ý³Ì£¬º¯Êý

ÔÚSQL SERVER 2005ÖбØÐëÓÃרÓùÜÀíÁ¬½Ó²Å¿ÉÒԲ鿴¹ý³Ì¹ý³ÌÖÐÓõ½µÄ±í
EG£ºsqlcmd -A
1>use test
2>go
1>sp_decrypt 'p_testa'
2>go
Text
----------------------
Create procedure P_testa
with encryption
as
select * from test
 
create PROCEDURE [dbo].[sp_decrypt]
(@procedure sysname = NULL)  
AS  
SET NOCOUNT ON  
BEGIN
DECLARE @intProcSpace bigint, @t bigint, @maxColID smallint,@intEncrypted  
tinyint,@procNameLength int  
select @maxColID = max(subobjid),@intEncrypted = imageval from  
sys.sysobjvalues WHERE objid = object_id(@procedure)  
GROUP BY imageval  
select @procNameLength = datalength(@procedure) + 29  
DECLARE @real_01 nvarchar(max)  
DECLARE @fake_01 nvarchar(max)  
DECLARE @fake_encrypt_01 nvarchar(max)  
DECLARE @real_decrypt_01 nvarchar(max),@real_decrypt_01a nvarchar(max)  
declare @objtype varchar(2),@ParentName nvarchar(max)  
select @real_decrypt_01a = ''  
--ÌáÈ¡¶ÔÏóµÄÀàÐÍÈçÊÇ´æ´¢¹ý³Ì»¹ÊǺ¯Êý£¬Èç¹ûÊÇ´¥·¢Æ÷£¬»¹ÒªµÃµ½Æ丸¶ÔÏóµÄÃû³Æ  
select @objtype=type,@parentname=object_name(parent_object_id)  
from sys.objects where [object_id]=object_id(@procedure)  
-- ´Ósys.sysobjvaluesÀïÌá³ö¼ÓÃܵÄimageval¼Ç¼  
SET @real_01=(SELECT top 1 imageval from sys.sysobjvalues WHERE objid =  
object_id(@procedure) and valclass = 1 order by subobjid)  
--´´½¨Ò»¸öÁÙʱ±í  
create table #output ( [ident] [int] IDENTITY (1, 1) NOT NULL ,  
[real_decrypt] NVARCHAR(MAX) )  
--¿ªÊ¼Ò»¸öÊÂÎñ£¬ÉÔºó»Ø¹ö  
BEGIN TRAN  
--¸ü¸ÄԭʼµÄ´æ´¢¹ý³Ì£¬Óö̺áÏßÌæ»»  
if @objtype='P'  
SET @fake_01='ALTER PROCEDURE '+ @procedure +' WITH ENCRYPTION AS  
'+REPLICATE('-', 40003 - @procNameLength)  
else if @objtype='FN'  
SET @fake_01