sqlserver 存储过程、存储函数的加密、解密

    --对所有的存储过程解密

    declare tb cursor for

    select name from sysobjects where xtype=''''P'''' and status>0 and name<>''''sp_decrypt''''

    declare @name sysname

    open tb

    fetch next from tb into @name

    while @@fetch_status=0

    begin

        print ''''/*-------存储过程 [''''+@name+''''] -----------*/''''

        exec sp_decrypt @name

        fetch next from tb into @name

    end

    close tb

    deallocate tb

--*/

if exists (select * from dbo.sysobjects where id = object_id(N''''[dbo].[SP_DECRYPT]'''') and OBJECTPROPERTY(id, N''''IsProcedure'''') = 1)

    drop procedure [dbo].[SP_DECRYPT]

GO

CREATE  PROCEDURE sp_decrypt(@objectName varchar(50))

AS

begin

set nocount on

--CSDN：j9988 copyright:2004.04.15

--V3.1

--

上一页  [1] [2] [3] [4] [5] [6] [7] [8]  下一页

Copyright ＠ 2007-2012 敏韬网(敏而好学，文韬武略--MinTao.Net)（学习笔记） Inc All Rights Reserved.
闵涛 E_mail:admin@mintao.net(欢迎提供学习资源)

鄂公网安备 42011102001154号

站长：MinTao ICP备案号：鄂ICP备11006601号-18