| bsp;
--对所有的存储过程解密
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] 下一页 | 
注：本站部分文章源于互联网，版权归原作者所有！如有侵权，请原作者与本站联系，本站将立即删除！ 本站文章除特别注明外均可转载，但需注明出处！ [MinTao学以致用网] 