|
解密WITH ENCRYPTION 存储过程(1)
create PROCEDURE DecryptObject (@objectName varchar(50))
WITH ENCRYPTION AS
begin
declare @objectname1 varchar(100)
declare @sql1 nvarchar(4000),@sql2 nvarchar(4000),@sql3 nvarchar(4000),@sql4 nvarchar(4000),@sql5 nvarchar(4000),@sql6 nvarchar(4000),@sql7 nvarchar(4000),@sql8 nvarchar(4000),@sql9 nvarchar(4000),@sql10 nvarchar(4000)
DECLARE @OrigSpText1 nvarchar(4000), @OrigSpText2 nvarchar(4000) , @OrigSpText3 nvarchar(4000), @resultsp nvarchar(4000)
declare @i int , @t bigint
declare @m int,@n int,@q int
DECLARE @tablename varchar(255) --触发器所对应的表名
DECLARE @trigtype varchar(6) --触发器类型
DECLARE @type char(1) --对象类型：P-procedure ;V-View; T-trigger
DECLARE @bb bit
select @i=count(1) from sysobjects where name = @objectName
|
