批量解密SQLSERVER数据库中的各种对象的工具dbForge SQL Decryptor 批量解密SQLSERVER数据库中的各种对象的工具dbForge SQL Decryptor2.1.11

 1 USE pratice
 2 GO
 3 
 4 SET ANSI_NULLS, QUOTED_IDENTIFIER ON
 5 GO
 6 /***************创建加密的存储过程*******************/
 7 Create Procedure CPP_test_Encryption 
 8 with encryption
 9 AS
10 ----可以换成任意的逻辑
11 execute CPP_test_Original
12 GO
13 
14 SET ANSI_NULLS, QUOTED_IDENTIFIER ON
15 GO
16 CREATE FUNCTION [dbo].f_get_page(@page_num BINARY(6))
17 RETURNS VARCHAR(11)
18 WITH ENCRYPTION
19 AS
20 BEGIN
21 RETURN(CONVERT(VARCHAR(2),(CONVERT(INT,SUBSTRING(@page_num,6,1))*POWER(2,8))+
22         (CONVERT(INT,SUBSTRING(@page_num,5,1))))+':'+
23         CONVERT(VARCHAR(11),
24         (CONVERT(INT,SUBSTRING(@page_num,4,1))*POWER(2,24))+
25         (CONVERT(INT,SUBSTRING(@page_num,3,1))*POWER(2,16))+
26         (CONVERT(INT,SUBSTRING(@page_num,2,1))*POWER(2,8))+
27         (CONVERT(INT,SUBSTRING(@page_num,1,1)))))
28 END
29 GO
30 
31 SET ANSI_NULLS, QUOTED_IDENTIFIER ON
32 GO
33 CREATE VIEW aa
34 WITH ENCRYPTION
35 AS
36 SELECT * FROM [dbo].[Users]
37 GO
38 
39 SET ANSI_NULLS, QUOTED_IDENTIFIER ON
40 GO
41 CREATE TRIGGER cc
42 ON [dbo].[Users]
43 WITH ENCRYPTION
44 FOR INSERT
45 AS RAISERROR(500001,16,10)
46 GO
47 
48 SET ANSI_NULLS, QUOTED_IDENTIFIER ON
49 GO
50 Create Procedure creat_test_Encryption 
51 with encryption
52 AS
53 SELECT TOP 100 * FROM [dbo].[test13]
54 
55 GO

1 SET ANSI_NULLS, QUOTED_IDENTIFIER ON
2 GO
3 ALTER Procedure creat_test_Encryption 
4 with encryption
5 AS
6 SELECT TOP 100 * FROM [dbo].[test13]
7 GO

1 SET ANSI_NULLS, QUOTED_IDENTIFIER ON
2 GO
3 ALTER Procedure creat_test_Encryption 
4 AS
5 SELECT TOP 100 * FROM [dbo].[test13]
6 GO