SQLSERVER对加密的存储过程、视图、触发器进行解密

加密测试的存储过程

IF EXISTS(SELECT 1 FROM SYSOBJECTS WHERE TYPE='P' AND NAME='P_TEST')
DROP PROCEDURE P_TEST
GO
CREATE PROCEDURE P_TEST(@USERNAME VARCHAR(20),@MSG VARCHAR(20) OUTPUT)
WITH ENCRYPTION
AS
BEGIN
    IF(SELECT COUNT(1) FROM Custs WHERE IF EXISTS(SELECT 1 FROM S